Show Permission

Show Permission : Permission : User Permission SQL / MySQL

SQL / MySQL » User Permission » 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;