What Are User Privileges in MySQL

Q

What Are User Privileges in MySQL?

✍: FYIcenter.com

A

MySQL offers many user privileges to control user accesses to different functions 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.

 

Managing User Accounts and Access Privileges in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 208👍, 0💬