创建用户

CREATE USER 'root'@'%' IDENTIFIED BY 'password';

创建用户并赋予指定权限

grant create,select,update,insert,delete,alter on bbs.* to lvtao@localhost identified by 'password';

创建用户并赋予全部权限

Grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;

创建备份用户

GRANT SELECT,RELOAD,SHOW DATABASES,LOCK TABLES,EVENT,REPLICATION CLIENT  ON *.* TO 'bak'@'localhost' IDENTIFIED BY 'password';

备份所有数据库

mysqldump -u root -p --all-databases --ignore-database=performance_schema --ignore-database=information_schema --skip-lock-tables > /home/db.sql

导出一个数据库结构