[BlueOnyx:20613] Re: Help! Yum has broken 5209R SQL

[Michael Stauber]

Hi Colin,

> Maybe the Salamanquesa one will give you a clue - it is non WP and very straight forward?

I just got it:

I created a simple PHP test script and populated it with the login
details from wp-config.php for MySQL

<?php
	$link = mysql_connect('localhost', 'wp-user', 'wp-password');
	if (!$link) {
	    die('Could not connect: ' . mysql_error());
	}
	echo 'Connected successfully';
	mysql_close($link);
?>

Called in a browser it yielded the source of the problem:

Could not connect: 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

Your my.cnf is fine. The issue is: The MySQL databases were imported
from an older version of MySQL during a migration. And they still use
the old password mechanism.

So the fix is simple:

Set all passwords for MySQL users again. For example through phpMyAdmin.
I just did this for the w...-safe site and Wordpress is working again
there.


-- 
With best regards

Michael Stauber