Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

More specifically, how do I show what replication grants is attached to a username?

share|improve this question

2 Answers 2

Try this:

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

This should give you output similar to that below:

+-----------+------------+------------+-----------------+------------------+
| 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)
share|improve this answer

For schema based privileges SELECT * FROM information_schema.schema_privileges

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.