MySQL 5.7 mysql.user 表没有 Password 字段改成 authentication_string;

创建用户

> CREATE USER 'username'@'localhost' IDENTIFIED BY '123456';

授权

> GRANT SELECT, INSERT, UPDATE ON database_name.* TO 'username'@'localhost';
> flush privileges

创建用户同时授权

> GRANT all privileges on database_name.* to username@localhost identified by '123456';
> flush privileges

设置与更改用户密码

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

撤销用户权限

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

删除用户

> DROP USER 'username'@'host';

查看用户的授权

> SHOW GRANTS FOR username@localhost;

GRANT USAGE,mysql usage 权限就是空权限,默认 create user 的权限,只能连库,啥也不能干。

06-01 16:27