|
/*
mysql> SHOW GRANTS FOR Joe@localhost;
+------------------------------------------------------------------------------------------------------------+
| Grants for Joe@localhost |
+------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'Joe'@'localhost' IDENTIFIED BY PASSWORD '*7341326DDB2391ED58CB4264AA085F5BF2F8B185' |
| GRANT SELECT ON `databasename`.* TO 'Joe'@'localhost' |
+------------------------------------------------------------------------------------------------------------+
2 rows in set (0.05 sec)
*/
SHOW GRANTS FOR Joe@localhost;
|