Mega Code Archive

 

Categories / MySQL / User 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;