mysql db management

tips.mysql.sh

# set pass in command line (non-interactive)
mysqladmin -u root password "some_new_password"

# set pass in command line (interactive)
mysqladmin -u root password

# login
mysql -u[name] -p[pass] [database]

# create backup
mysqldum -u[name] -p[pass] [database] > backup.sql

# create backup for all databases
mysqldum -u[name] -p[pass] --all-databases > backup.sql

# restore backup file
mysql -u[name] -p[pass] [database] < backup.sql