MySQL adding user and more …

Notes to my self:

Adding user to database:

GRANT ALL PRIVILEGES ON *.* TO 'zuan'@'localhost'

 IDENTIFIED BY 'password' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'zuan'@'%'

 IDENTIFIED BY 'password' WITH GRANT OPTION;

Backup and restore:

mysqldump -u zuan -p databasename > backup.sql

Restore:

mysql -u zuan -p databasename < backup.sql

Thank You,