Managing MySQL User Permissions in cPanel
Quick Navigation Links
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:
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
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
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.
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