mysql

select '客户端ip段限制' as 'Host',
'用户名' as 'User',
'查询权限' as 'Select_priv',
'写入权限' as 'Insert_priv',
'更新权限' as 'Update_priv',
'删除权限' as 'Delete_priv',
'创建库和表' as 'Create_priv',
'删除库和表' as 'Drop_priv',
'执行刷新和重新加载mysql所用各种内部缓存的特定命令，包含日志，权限，主机，查询和表' as 'Reload_priv',
'关闭mysql服务器' as 'Shutdown_priv',
'通过show processlist查看其他用户的进程' as 'Process_priv',
'执行select into outfile 和load data infile 导入和导出数据命令' as 'File_priv',
'将自己的权限再授予其他用户' as 'Grant_priv',
'创建外键约束' as 'References_priv',
'对索引进行增删查' as 'Index_priv',
'重命名和修改表结构' as 'Alter_priv',
'查看服务器上所有数据库的名字' as 'Show_db_priv',
'执行某些强大的管理功能，如：kill命令删除用户进程；使用set golbal修改全局变量；执行关于复制和日志的各种命令（超级功能）' as 'Super_priv',
'创建临时表' as 'Create_tmp_table_priv',
'使用lock tables 命令' as 'Lock_tables_priv',
'执行存储过程' as 'Execute_priv',
'读取用于维护复制数据库环境的二进制日志文件' as 'Repl_slave_priv',
'确定复制从服务器和主服务器的位置' as 'Repl_client_priv',
'创建视图' as 'Create_view_priv',
'查看视图' as 'Show_view_priv',
'更改或放弃存储过程和函数' as 'Create_routine_priv',
'修改或删除存储过程及函数' as 'Alter_routine_priv',
'执行create user新建用户命令' as 'Create_user_priv',
'创建，修改，删除事件' as 'Event_priv',
'创建，删除触发器' as 'Trigger_priv',
'创建表空间' as 'Create_tablespace_priv',
'支持ssl标准加密安全字段' as 'ssl_type',
'支持ssl标准加密安全字段' as 'ssl_cipher',
'支持x509标准字段' as 'x509_issuer',
'支持x510标准字段' as 'x509_subject',
'每小时允许执行多少次查询' as 'max_questions',
'每小时可执行多少次更新，0标识无限制' as 'max_updates',
'每小时可以建立多少次链接' as 'max_connections',
'单用户可以同时具有的连接数' as 'max_user_connections',
'引用plugins以进行用户连接时的密码验证，plugin创建外部/代理用户' as 'plugin',
'密码' as 'authentication_string',
'密码过期，Y说明已过期' as 'password_expired'
union all
select `Host`,`User`,`Select_priv`,`Insert_priv`,`Update_priv`,`Delete_priv`,`Create_priv`,`Drop_priv`,`Reload_priv`,`Shutdown_priv`,`Process_priv`,`File_priv`,`Grant_priv`,`References_priv`,`Index_priv`,`Alter_priv`,`Show_db_priv`,`Super_priv`,`Create_tmp_table_priv`,`Lock_tables_priv`,`Execute_priv`,`Repl_slave_priv`,`Repl_client_priv`,`Create_view_priv`,`Show_view_priv`,`Create_routine_priv`,`Alter_routine_priv`,`Create_user_priv`,`Event_priv`,`Trigger_priv`,`Create_tablespace_priv`,`ssl_type`,`ssl_cipher`,`x509_issuer`,`x509_subject`,`max_questions`,`max_updates`,`max_connections`,`max_user_connections`,`plugin`,`authentication_string`,`password_expired` from mysql.user