How to Add MySQL Database User to a MySQL Database With Specific Privileges
This tutorial assumes that you have already created your database and database user.
1. Login to cPanel to accomplish this task.
2. Navigate to the “Databases” section and click on “MySQL Databases” .
3. Go to the section written “Add User To Database” and select your user and the database you are assigning him to and click on the button “Add”.
4. Select the privileges that you want this user to have, if you want them to do everything tick the “ALL PRIVILEGES” field at the top. Click on the button “Make Changes” to save.