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 的权限,只能连库,啥也不能干。