#查看当前用户权限 SHOW GRANTS; #想查看特定用户的权限 SHOW GRANTS FOR 'username'@'host'; #将'username'替换为您想要查看权限的用户名,'host'替换为该用户可以从中登录的主机名。 SELECT user, host FROM mysql.user; use mysql; #创建用户: CREATE USER 'root'@'nsp-mysql' IDENTIFIED BY 'password'; #授权 GRANT ALL PRIVILEGES ON database_name.table_name TO 'root'@'localhost'; FLUSH PRIVILEGES;
03-22
9364
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
09-07
2200
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
11-24
2万+
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-11
4663
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
03-09