MySQL数据库 - 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';