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,