Archive for the 'PHP' Category

This error message occurs if you try with PHP 5.3 on a MySQL server to access and use the account or the MySQL server is "old-password". PHP 5.3 uses the new native MySQL extension mysqlnd, which is not old-password support.

Old-password is not used on purpose, it is probably an old account. The password must be reset by:

SET PASSWORD FOR 'account'@'localhost' = PASSWORD('passwort');

In order for a new hash is created.

Old-password is used intentionally (old connectors), so you have to go back to PHP 5.2. There, using the MySQL extension mysql the usual mechanisms.

Which accounts are affected, you can check with:

SELECT Host, User, Password FROM mysql.user;

16 places in the Password column = old password
41 points in the Password column = new password