The “Acesss denied for the user to the database” is a very common Mysql error. The Mysql error is occur due to the Mysql database username is not bind to the Mysql database therefore “Acesss denied for the user to the database” is occur.As soon as we create the MySQL database user then we will need to be given a privilege to access the specific databases to the newly created Mysql database user. Refer to the following steps to assign the privilege for Mysql database user to connect specific Mysql database.
Steps
1 Click on the Mysql icon above the words MySQL Databases on the cPanel main screen interface.
2 Select the Mysql Database user you want to grant privilege/ permissions from the drop box next to “Add User To Database” section:
3 Select the privileges which you want to grant the user to have by checking the box next to the privilege’s name.
4 Click Make changes button to Db to give the user permission to access the database.
You can also refer the following Video
Grant Privilege To Mysql Database User
