To give a user all privileges in MySQL, follow these steps:
Log in to your cPanel account.
From the Databases section, pick “MySQL® Databases”.
Add a user from "Add User To Database” section under the MySQL Users section. Choose the User to whom you’d like to grant rights, as well as the Database to which you’d like to do so. Then, on the next screen, click the Add button.
You’ll be taken to “Manage User Privileges”, where you can select the user’s privileges.
To grant the user all privileges, check the ALL PRIVILEGES box and click the Make Changes button.
When you have successfully granted previllages, a pop-up success message, will come, indicating that the user’s selected privileges have been saved.
By this your user have the privillages.
