Log into your cPanel account.
In the Databases
section, click on MySQL Databases
Scroll down to the end of the page and under Add User to Database
, select a user from the dropdown list, and then choose a Database from the list.
Click on the Add
On Manage User Privileges
, mark the box ALL PRIVILEGES
and click on Make Changes