查看MySQL某个用户的权限:
show grants for 用户名
示例:
MariaDB [neutron]> show grants for root;
扩展:
用GRANT命令建立新用户、设定用户密码、并增加用户权限。其格式如下:
mysql> GRANT <privileges> ON <what> TO <user> [IDENTIFIED BY "<password>"] [WITH GRANT OPTION];
推荐: