Skip to main content
MySQL database users can be granted a range of privileges to restrict or grant access to a given database. Typical privileges include INSERT, UPDATE, SELECT, and DELETE, among others, that represent actions or queries a user might run against a database. Some people use these privileges to restrict DELETE or other potentially harmful queries to a specific scope or method of access. That said, for most modern web applications you will need to grant ‘all privileges’ to a database user to ensure the user can connect to and manipulate the database in the way the application expects. Creating a post in WordPress, for example, involves SELECT and INSERT queries, while removing a plugin might involve DELETE and UPDATE queries. If you haven’t already created a MySQL database, please read Creating MySQL Databases and Users. To access the MySQL user privileges section:
  1. Log in to cPanel and click MySQL Databases.
  2. Scroll down and find Add User to Database.
  3. Select the specific user from the User drop-down.
  4. Select the database you want to grant or adjust privileges on in the Database drop-down.
  5. Click Add, and then you can manage the privileges granted to that specific user on that specific database.