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:
- Scroll down to the Add User to Database section
- From the first dropdown box select the User
- From the second dropdown box select the database
- Click the Add button
- Choose the permissions you want the user to have, or select All Privileges if you want to give them all.
- Click the Make Changes button
How do I modify a user’s permissions in a MySQL Database?
- If you want to modify the permissions you provided a user, then head back into the Current Databases section of Databases.
- Click on the username next to the database that you want to update.
- The user permission options will appear in a series of check boxes, similar to before.
- 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?
- Towards the bottom of MYSQL Databases is a list of any and all users created
- You can manage the users password, edit their user name, or delete entirely