show granted privileges for a certain user in mysql


https://dev.mysql.com/doc/refman/5.0/en/show-grants.html

mysql> SHOW GRANTS FOR 'root'@'localhost';
mysql> SHOW GRANTS;
mysql> SHOW GRANTS FOR CURRENT_USER;
mysql> SHOW GRANTS FOR CURRENT_USER();

mysql> select user,host from mysql.user;
mysql> show grants for repli_user@3hd.me ;

GRANT REPLICATION SLAVE ON *.* TO 'repli_user'@'3hd.me' IDENTIFIED BY PASSWORD 'xvf1E7fda4dsf9xxxxx'