创建用户CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']删除用户DROP USER user [, user] ...刷新权限FLUSH PRIVILEGES分配权限GRANT priv_type,...
ON [object_type] {tbl_name | * | *.* | db_name.*}
TO user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
[WITH with_option]用户名称重命名RENAME USER old_user TO new_user
[, old_user TO new_user] ...收回权限REVOKE priv_type, ...
ON [object_type] {tbl_name | * | *.* | db_name.*}
FROM user [, user] ...收回全部权限REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ...设置新密码SET PASSWORD FOR user = PASSWORD('some password')
作者:liuawei
链接:https://www.jianshu.com/p/ccbb57597db4