Can't add user to database

[dragos03]

I have a really strange error on an older WHM server (version 11.50), did anyone else run into it?

I created a new database from cPanel, when I try to add a particular user to it, I get the message "You have successfully granted privileges on the database". However, the privileges are not granted.

If I try to add a different user, it works without any issues.

The error in the logs is:

warn [cpmysql] The user “x” is not permitted to add the “x” database user to the database “x”. Either the user does not exist, or the user does not have a password. at /usr/local/cpanel/Cpanel/DBAdmin.pm line 168

The user does have a password and it is correct. I tried restarting cPanel services, resetting the cPanel and MySQL passwords for that user as well as deleting and creating the database again with lo luck.

Any ideas?

 

[Infopro]

Only one, really, you should update that server's cPanel installation.

 

[dragos03]

That would obviously help but it's an old CentOS 5 server that can't be upgraded. It will be replaced soon with a new machine running the latest CentOS and WHM versions, but I have to keep the current server running until then.

 

[cPanelMichael]

Hello @dragos03,

cPanel & WHM version 56 is the last version to support CentOS 5. While it's unsupported and end-of-life, you may want to try upgrading from cPanel & WHM version 50 to cPanel & WHM version 56 to see if that helps. Alternatively, you could try modifying the cPanel account's password and checking to see if the issue persists.

If the above options don't help, you'll need to upgrade to a cPanel & WHM version that's supported.

Thank you.