更具体地说,我如何显示什么复制授予附加到用户名?
尝试这个:
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