mysql 查询用户权限

select * from mysql.user where user='root' \G; 查询某个具体用户的权限

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;  查询所有用户权限

无可奈何花落去,似曾相识燕归来
原文地址:https://www.cnblogs.com/MUQINGFENG123/p/10904363.html