How to add a user to a MySQL Databases in cPanel
How To Add a user to a database
To add a user to a database, perform the following steps:
1 – Open cPanel (yourdomain/cpanel).
2 – Click on (MySQL® Databases) from Databases section.
3 – In the Add User To Database section of the interface, select the desired user and database from the menus.
4 – Click Add. The MySQL Account Maintenance interface will appear.
5 – Select the checkboxes that correspond to the privileges that you wish to grant to the user.
6 – Click Make Changes.
7 – Click Go Back to return to the main interface