Failed to connect to your database server. The server reports the following message: SQLSTATE[HY000] [2000] 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.

Failed to connect to your database server. The server reports the following message: SQLSTATE[HY000] [2000]

For a D7 site in my case, there is a setting in my webhosting Parallel Servobox Control Panel, a MySQL password hash length setting in password setting. Toggling it from: "Short, compatible with all PHP versions" to "Long, PHP5.x-only" fixed the issue and installation proceeded.

Prior also, I had to change the host setting from "localhost" to "127.0.0.1" to proceed with the database installation step. This might help for those needing to change the host in settings.php for already installed sites.

SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication

Leave a Comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
To prevent automated spam submissions leave this field empty.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
6 + 7 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.
Get reliable web hosting services

Recurring donation

Make Donation

  • Other: $

Donate now

Single donation

Make Donation

  • Other: $

Donate now