One of the most common errors when creating a new
MySQL database is that you may forget to grant privileges to the
database user, in this knowledge base article we will review how to
correct this issue.
After creating the database, and then
creating the database user, it is important to grant the required
privileges to the database user, this will allow the database user to be
able to access and modify your database. Listed below are the steps to
check that the database user has correctly been assigned to the
database:
1. Login to cPanel
2. Locate the MySQL Databases icon under the Databases tab
3. Scroll down to the bottom of the page
4. Select the database user that you want to grant permissions to and select the database name as well
5. Click on the 'Add' button
6. In the Manage User Privileges page you can select the 'All privileges' checkbox and save (Make Changes).
