SQL/MySQL/User Permission/Permission

Show Permission

   <source lang="sql">

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

      </source>