To login (from unix shell) use -h only if needed. # [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. mysql> create database [databasename]; List all databases on the sql server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all …
Magento 1.9 sample data with no admin login
Today our team installed Magento 1.9 with sample data provided by Magento but the sample data provided by Magento didn’t have any admin login So our team spent 30 mins to write a mysql script which we thought we must share with the community to save time for others. Create …
Resetting admin password magento
It seems like the password must be typed and not copy/paste at least on the install part. good to know ;o) The default login is : admin The default password is : 123123 If you are having troubles and want to reset it to a different password, just run at …
rsync and mysqldump mysql for wordpress
rsync -auvz –rsh=”ssh -p 22 [email protected]:/var/www/www.example.it/www /vagrant/www/wordpress-website mysqldump –add-drop-table –lock-tables=false -h localhost -u user -p databasename | gzip > website.bak.sql.gz mysql -u root -p -h localhost wordpress_fmcinema < data.sql
Upload MySql Connection/J to tomcat lib folder
Upload latest version of mysql connector/j (at time of writing 5.1.21) and place in /usr/share/tomcat7/lib folder. sudo mv mysql-connector-java-5.1.21.jar /usr/share/tomcat7/lib/