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

[Colin Jack]

Hi Michael,

> 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.

Yes - this was originally a 5106R box
 
> 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.
> 

Many thanks - I will go through and repair as necessary.
Appreciate your quick response and help.

Regards

Colin