MySQL用户管理

1.md

创建用户：

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

删除用户：

DROP USER 'username'@'host';

授权：

# privileges: ALL/SELECT/INSERT/UPDATE/DELETE/...
# @see https://dev.mysql.com/doc/refman/5.5/en/privileges-provided.html
GRANT privileges ON databasename.tablename TO 'username'@'host';
#flush privileges;

撤销授权：

REVOKE privilege ON databasename.tablename FROM 'username'@'host';

查看授权：

SHOW GRANTS FOR 'username'@'host'；

修改密码：

SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');

当前用户修改密码：

SET PASSWORD = PASSWORD("newpassword");