CREATE USER 'xxxx'@'localhost' IDENTIFIED BY 'xxxxx';
DROP USER xxxx;
DROP USER 'xxxx'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
REVOKE ALL PRIVILEGES ON *.* FROM 'user'@'%';
REVOKE GRANT OPTION ON *.* FROM 'user'@'%';
FLUSH PRIVILEGES;
mysqldump --default-character-set utf8mb4 -u root -p lhen > lhen-release.sql
mysql -u 用户名 -p --database 数据库名 < D:abc.sql
07 Feb 2018