如何在Mysql上显示用户名的授权?

更具体地说,我如何显示什么复制授予附加到用户名?

尝试这个:

mysql> select Host, User, grant_priv, Repl_slave_priv, Repl_client_priv from mysql.user; 

这应该给你类似于下面的输出:

 +-----------+------------+------------+-----------------+------------------+ | Host | User | grant_priv | Repl_slave_priv | Repl_client_priv | +-----------+------------+------------+-----------------+------------------+ | localhost | root | Y | Y | Y | | localhost | dlo | Y | Y | Y | +-----------+------------+------------+-----------------+------------------+ 2 rows in set (0.00 sec) 

对于基于模式的权限SELECT * FROM information_schema.schema_privileges