Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Viewing User Privileges

By: FYIcenter.com

(Continued from previous topic...)

How To View User Privileges?

If a regular user wants to see his/her own granted privileges, he/she can use the "SHOW GRANTS" command. If the "root" user wants to see other user's granted privileges, he/she can use the "SHOW GRANTS FOR userName" command. The following tutorial exercise shows you how to view user's granted privileges:

>cd \mysql\bin
>mysql -u root -pretneciyf

mysql> SHOW GRANTS;
+------------------------------------------------------
| Grants for root@localhost                            
+------------------------------------------------------
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'...
+------------------------------------------------------
1 row in set (0.00 sec)

mysql> SHOW GRANTS for dev;
+------------------------------------------------------
| Grants for dev@%                      |
+------------------------------------------------------
| GRANT CREATE ON *.* TO 'dev'@'%' ... 
+------------------------------------------------------
1 row in set (0.00 sec)

mysql> SHOW GRANTS for qa;
+------------------------------------------------------
| Grants for qa@%                    |
+------------------------------------------------------
| GRANT USAGE ON *.* TO 'qa'@'%' ...
| GRANT CREATE ON `faq`.* TO 'qa'@'%'                  
+------------------------------------------------------
2 rows in set (0.00 sec)

The output says:

  • "root" has all privileges on all databases.
  • "dev" has only "CREATE" privilege on all databases.
  • "qa" has no privileges on any databases, except for "CREATE" privilege on "faq" database.

(Continued on next topic...)

  1. What Is a User Account?
  2. What Are the Predefined User Accounts?
  3. How To Add a New User Account?
  4. How To Test a New User Account and Password?
  5. How To Change the Password for Your Own User Account?
  6. How To Change the Password of Another User Account?
  7. How To Delete a User Account?
  8. How To List All Existing User Accounts?
  9. How To Rename an Existing User Account Name?
  10. What Are User Privileges?
  11. How Many Scope Levels Can User Privileges Apply?
  12. How To Grant User Privileges at the Global Level?
  13. How To Grant User Privileges at the Database Level?
  14. How To View User Privileges?
  15. How To Revoke User Privileges?
  16. How To Give a User Read-Only Access to a Database?
  17. Where Are User Privileges Stored on the Server?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...