1、查看某用户的表权限
select * from information_schema.table_privileges where grantee=‘user_name‘;
2、查看usage权限表
select * from information_schema.usage_privileges where grantee=‘user_name‘;
3、查看存储过程函数相关权限表
select * from information_schema.routine_privileges where grantee=‘user_name‘;
4、建用户授权
create user user_name; alter user user_namewith password ‘‘; alter user user_namewith CONNECTION LIMIT 20;#连接数限制
本文出自 “composer” 博客，请务必保留此出处http://zuoqujia.blog.51cto.com/9151800/1438179