Upgraded to PHP 5.6, unable to make MySQL connection

Question

I upgraded from PHP 5.3 to 5.6 to take advantage of >2GB upload capability in 5.6. In doing so, the following line dies:

$db = ($GLOBALS["___mysqli_ston"] = mysqli_connect($dbhost,  $dbuser, $dbpass))
    or die("The site database appears to be down.");

The logfile message is:

mysqli_connect(): The server requested authentication method unknown to the client

What about upgrading to PHP 5.6 would cause this line to fail?

maybe `die( "Database error: " . mysqli_error($GLOBALS["___mysqli_ston"]) )` will tell you. — Gerald Schneider, Oct 23 '14 at 13:05
http://stackoverflow.com/questions/17386567/changing-from-mysql-to-mysqli-code-error — Len_D, Oct 23 '14 at 13:08
@Len, this code was converted years ago and works fine under PHP 5.3. Checking into first comment now. — a coder, Oct 23 '14 at 13:10
@Qual - agreed. Legacy site involved and these MySQL calls need to be migrated to something modern. Right now trying to get the site working and usable. — a coder, Oct 23 '14 at 13:10
well, did you upgrade by chance mysql as well? then resetting the password on the mysql side should suffice. — Gerald Schneider, Oct 23 '14 at 13:12
Have a look at this article http://php.net/manual/en/ref.mysqli.php and to Elitscripts2000's comment. Maybe it helps. — damko, Oct 23 '14 at 13:13
Actually, yes - MySQL was updated as well. That makes the log error clearer now. `The server requested authentication method unknown to the client`. — a coder, Oct 23 '14 at 13:13
@acoder try to re-set the password for the MySQL user, maybe? — ItalyPaleAle, Oct 23 '14 at 13:15
I reset pw using `UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES;` - still getting same errors in log. — a coder, Oct 23 '14 at 13:22
This could be helpful: http://dev.mysql.com/doc/refman/5.0/en/old-client.html — Gerald Schneider, Oct 23 '14 at 13:24
This solved the issue: http://stackoverflow.com/a/1340538/721073 — a coder, Oct 23 '14 at 13:31

score 2 · Answer 1 · edited May 23 '17 at 12:15

Issue resolved. MySQL was updated at the same time as PHP. The old version of MySQL used the old password style, which didn't work with the new version of PHP.

The solution was to log into MySQL on the server and reset passwords from the old 16 character hashes to the new ~40 character hashes.

SET PASSWORD FOR 'someuser'@'localhost' = PASSWORD('somepassword');
FLUSH PRIVILEGES;

Once that was done the site is working OK again.

Upgraded to PHP 5.6, unable to make MySQL connection

1 Answers1