Help with resolving db error message
3 posts by 2 authors in: Forums > CMS Builder
Last Post: May 25, 2011 (RSS)
By zip222 - May 24, 2011
it seems that the hosting company for one of our sites made some change that is causing the error below. any thoughts on how to resolve this?
The database error given was:
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
Re: [zip222] Help with resolving db error message
By robin - May 25, 2011
Hey Zip,
Looks like your hosting company probably upgraded to PHP 5.3 and didn't configure it for old style mysql passwords. They might have upgraded/changed mysql also.
The first and easiest thing to try is to reset your mysql password to the same thing it was before. That will hopefully re-hash your password on the mysql server to the new style hash and everything will work again.
fyi:
http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html
Hope that helps,
Robin
Looks like your hosting company probably upgraded to PHP 5.3 and didn't configure it for old style mysql passwords. They might have upgraded/changed mysql also.
The first and easiest thing to try is to reset your mysql password to the same thing it was before. That will hopefully re-hash your password on the mysql server to the new style hash and everything will work again.
fyi:
http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html
Hope that helps,
Robin
Robin
Programmer
interactivetools.com
Programmer
interactivetools.com
Re: [robin] Help with resolving db error message
By zip222 - May 25, 2011
My client, the owner of the site, just called the hosting company and they undid whatever change they made. Thanks.