General Guides

Search Knowledge Base by Keyword

Managing MySQL User Permissions in cPanel

You are here:
Share:

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

Step One: Scroll down to the Add User to Database section

Step Two: From the first dropdown box select the User

Step Three: From the second dropdown box select the database

Step Four: Click the Add button

Showing Add User To Database form in cPanel 

Step Five: Choose the permissions you want the user to have, or select All Privileges if you want to give them all.

Step Six: Click the Make Changes button

Showing MySQL Manage User Privileges form 

 

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

Step One: If you want to modify the permissions you provided a user, then head back into the Current Databases section of Databases.  

Step Two: Click on the username next to the database that you want to update.

 

Showing how to modify MySQL user permissions in cPanel

 

Step Three: The user permission options will appear in a series of check boxes, similar to before.

Step Four: 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?

Step One: Towards the bottom of MYSQL Databases is a list of any and all users created

Step Two: You can manage the users password, edit their user name, or delete entirely


cpanel current user database location


Share: