Navicat：Navicat for MySQL: SQL预览，可以查看图形化操作转换成命令、查看历史记录就可以查看到对应的命令

Navicat：Navicat for MySQL: SQL预览，可以查看图形化操作转换成命令、查看历史记录就可以查看到对应的命令

CREATE USER 'root1'@'localhost' IDENTIFIED BY 'P@ssw0rd1';

GRANT GRANT OPTION ON *.* TO 'root'@'localhost';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'root'@'localhost';

查看历史记录：

数据库管理工具（列表、list、全）
http://www.zh-cjh.com/wenzhangguilei/719.html
文章归类、所有文章列表、LISTLIST
http://www.zh-cjh.com/wangzhangonggao/2195.html