MySQL database and user exists but I get access denied errors
This article was posted in: Web Hosting
A common error when creating a MySQL database is that one can forget to grant privileges to the user.
After creating the database, and then creating the user, it is important to grant privileges to the user.
Go to the Database section of cPanel, and click on the MySQL Databases icon.
Scroll down to the bottom of the page, and you will find this area (shown below).
Each user can have different privileges for each database, so it's important to select the correct user and the database from the User (1) and Database (2) drop down controls. Click on the Add (3) button.
This will open the Manage User Privileges screen (shown below). Unless you have very specific requirements you can grant all rights to the user for the database concerned by setting the ALL PRIVILEGES check box.