How to assign privileges to users on databases that are created in Cpanel

[VFRodriguez]

I remember that I used to assign privileges to users in cPanel. I don't find this option now. I am having problem when trying to INSERT DATA into tables using PHP. I receive errors like "Access denied for user..."

[navaldesign]

Re: How to assign privileges to users on databases that are created in Cpanel

Go in cPnel
Click on the MySQL Databases icon
In the next screen, scroll down and find the "Add user to database" section
Select the user you want and ADD him to the desired database (even if he was already added in the past)
As soon as you do so, the Privileges screen will open where you can assign / modify privilleges of the specific user for the specific database.