Managing MySQL User Permissions in cPanel

There are times when a database user does not need to have full permissions to a database in order to interact with a MySQL Database. If you ever need to create a user with restricted permissions, this guide will help you do just that.

How do I Create Permissions for MySQL Databases?

MySQL users can be setup with certain permissions to regulate their access.  What users are allowed to do include SELECT, INSERT, UPDATE and DELETE.  This guide will show you, the administrator, how to set or revoke those privileges through your cPanel account.

To get started, you will want to go to: Home > Databases > MySQL Databases as shown in this image:
Showing the MySQL Databases icon in cPanel

  1. Scroll down to the Add User to Database section
  2. From the first dropdown box select the User
  3. From the second dropdown box select the database
  4. Click the Add button
    Showing Add User To Database form in cPanel 
  5. Choose the permissions you want the user to have, or select All Privileges if you want to give them all.
  6. Click the Make Changes button
    Showing MySQL Manage User Privileges form 


How do I modify a user’s permissions in a MySQL Database?

  1. If you want to modify the permissions you provided a user, then head back into the Current Databases section of Databases.  
  2. Click on the username next to the database that you want to update.
    Showing how to modify MySQL user permissions in cPanel
  3. The user permission options will appear in a series of check boxes, similar to before.
  4. Check the box you want to update their permissions to, and click the Make Changes button.



How do I review current users, change their password, or delete?


  1. Towards the bottom of MYSQL Databases is a list of any and all users created
  2. You can manage the users password, edit their user name, or delete entirely
    cpanel current user database location
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Adding a MySQL user to a database

How do I Add a User to a MySQL Database? You can easily add a user to specific MySQL...

Application Cannot Connect to Database

What causes an application cannot connect to database error? There are several things that...

Creating a MySQL Database

How do I Setup a MySQL Database in cPanel? Setting up a database for your website can be done...

Creating a MySQL User

How Do I Create A MySQL User In cPanel? To create a MySQL user follow the guide below.  This...

Definition of Databases Icons

The Database section in cPanel allows you to administer every aspect of your MySQL database....