How to set user permissions for MySQL database?

1. Login to cPanel.

2. Click on “MySQL Database ”.

3. Select the user (the user will appear as mainuser_user) you wish to grant permissions for from the drop box next to User:

4. Select the database (the database will appear as mainuser_database) you wish to give that user access to from the drop box next to Db:

5. Select any privileges (abilities to modify the database) you wish the user to have by checking the box next to the privilege’s name.

6. Click on Add User to Db to give the user permission to access the database.