cPanel Bug with MySQL

Hello WHT'ers,

I am having a current issue with one of my VPSs at ServInt. The issue is whenever a database user is created in cPanel it is created in a way that the script will not be able to connect to MySQL. I e-mailed their NOC and they opened up a ticket in the engineering department for me. Here is the response I got:
-------------------------------------------------------------------
Hi,

This is a bug in the way that cPanel creates users and passwords. Here is
the manual way to fix the problem (for individual database users). You
will need to run the following mysql command:

set password for 'dbuser'@'localhost' = OLD_PASSWORD('dbpass');

In the above command 'dbuser' is the username for the particular database
and 'dbpass' is the password that was created.

Unfortunately as of right now I know of no way to work around doing this
manually for individual scripts.

--Giles
--ServInt Engineering
-------------------------------------------------------------------

Do any of you know a way of fixing this or working around because this seems to be quite a major problem for me on this VPS.

I am running the following versions of cPanel and MySQL.
-- mysql (4.1.10-standard)
-- WHM 10.0.0 cPanel 10.0.0-R143

Thank you for your help with this.

 

 

 

 

Top