- +在此添加单个AI新笔记
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等，如果要授予所的权限则使用ALLdatabasename：数据库名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");