Tag: SQL
MySQL Commands
Some of the most important SQL commands
Connect to MySQL Server:
mysql -u UserName -p
Show Users:
SELECT user FROM mysql.user;
Show Users and Hosts:
SELECT user,host FROM mysql.user;
Change Password...
mysqldump Backup Database and mysql Restore Database
Below are examples of backing up databases and examples of restoring database backups.
Backup:
mysqldump -u -p > /path/to/file.sql
Restore:
mysql -u -p <...
