MySQL uses a permission system called “privileges” that the administrator can grant to other users. Some of those privileges include functionality such as: SELECT, INSERT, UPDATE, and DELETE. The administrator has the power to grant or revoke privileges from anyone at any time. You can easily assign privileges to MySQL users for specific databases using cPanel.
For example, if you have a user named “misty” and database named “snowcones”, you would grant misty privileges to the database by doing the following:
- Login to cPanel and navigate to the “Databases” section
- Click “MySQL Databases”
- Scroll down to the section labeled “Add User to Database”
- Select the user from the first dropdown menu and the database from the second (in this case, “misty” and “snowcones”)
- Click “Add”
- Select the privileges you want to grant to the user or select “All Prvileges” to grant all of them.
- Click “Make Changes” to finalize it.
If you ever need to modify privileges for a user already associated with a database, find the section labeled “Current Databases” and click on the username next to the database in question. It will then give you the same privileges page on which you can revoke or grant privileges simply by checking the boxes.