30 - Mysql - 用户管理权限

# root身份进入mysql库
mysql>  use mysql; 
mysql>  select host,user,plugin  from user;
mysql>  select host,user,plugin,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv from user;
# 查user表
SHOW GRANTS FOR 'xxx'@'localhost';  查权限

https://www.cnblogs.com/zhongyehai/p/10695659.html

创建用户

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

配置权限

# 命令:
GRANT privileges ON databasename.tablename TO 'username'@'host'
# 说明:
privileges：用户的操作权限，如SELECT，INSERT，UPDATE等，如果要授予所的权限则使用ALL
databasename：数据库名
tablename：表名，如果要授予该用户对所有数据库和表的相应操作权限则可用*表示，如*.*
# 例子:
GRANT SELECT, INSERT ON test.user TO 'pig'@'%';
GRANT ALL ON *.* TO 'pig'@'%';
GRANT ALL ON maindataplus.* TO 'pig'@'%';
# 注意:
# 用以上命令授权的用户不能给其它用户授权，如果想让该用户可以授权，用以下命令:
GRANT privileges ON databasename.tablename TO 'username'@'host' WITH GRANT OPTION;

删除用户

DROP USER 'username'@'host';

设置与更改用户密码

# 命令:
SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');
# 如果是当前登陆用户用:
SET PASSWORD = PASSWORD("newpassword");
# 例子:
SET PASSWORD FOR 'pig'@'%' = PASSWORD("123456");