User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. 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;