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 aswell
5. Click on the 'Add' button
6. In the Manage User Privileges page you can select the 'All privileges' checkbox and save

If you are still experiencing problems or need further assistance please contact our support team via https://www.panthur.com.au/contact