Could not connect MySQL 4.1+ using the old insecure

[larneman]

Support Request Template
What version of phpBB are you using? phpBB 3.2.0
What is your board's URL? http://www.irishgenealogy.net/forum/phpbb3/install/
Who do you host your board with? jodohost.com
How did you install your board? I used the update package from phpBB.com
What is the most recent action performed on your board? Installed phpBB 3.2.0
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What version of phpBB3 did you update from? phpBB 3.2.0
What styles do you currently have installed? No idea
What language(s) is your board currently using? English
Which database type/version are you using? MySQL
What is your level of experience? Beginner
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Finished filling scree and clicked on INSTALL..

Please describe your problem.

Ran http://www.irishgenealogy.net/forum/php ... update.php

Got this message:-

Could not connect to the database, see error message below.
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

I have read the 3 topic's on this Forum that have had the same problem but not with phpBB 3.2.
I have read somewhere after resetting the password using phpMyadmin that I should close down the database or use the MYSQL command "Flush Privileges"

My password is correct as is the database name and database user because I can access phpMyadmin and the Database with database password and database user.

I hope that when you actually read the error message that you can help.

[larneman]

Thanks for all the support.

[Noxwizard]

This issue isn't specific to phpBB, so topics with this error for other versions of phpBB will be relevant. Most likely your host has updated the MySQL server and it still has old style passwords in it, which PHP no longer allows. You have to reset the database password and make sure it's using MySQL's new hashing mechanism. phpMyAdmin usually allows you to change the password and to select a MySQL 4.1+ compatible password. If you aren't able to reset the password to the new style, you will need to ask your host to do it or disable old style passwords entirely.