SQL/MySQL/User Permission/Permission

Show Permission

/*
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;