Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - What Are User Privileges

By: FYIcenter.com

(Continued from previous topic...)

What Are User Privileges?

MySQL offers many user privileges to control user accesses to different funtions and data objects. Here are some commonly used privileges:

  • ALL - All privileges.
  • CREATE - Allows the user to use CREATE TABLE commands.
  • ALTER - Allows the user to use ALTER TABLE commands.
  • DROP - Allows the user to use DROP TABLE commands.
  • DELETE - Allows the user to use DELETE commands.
  • INSERT - Allows the user to use INSERT commands.
  • UPDATE - Allows the user to use UPDATE commands.
  • SELECT - Allows the user to use SELECT commands.
  • SHUTDOWN - Allows the user to use "mysqladmin shutdown".
  • INDEX - Allows the user to create and drop indexes.
  • CREATE USER - Allows the user to manage user accounts.
  • CREATE VIEW - Allows the user to user "CREATE VIEW" commands.
  • USAGE - No privileges.

(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...