Fast2Host Logo


MySQL 4.1+ using the old insecure authentication

MySQL extension for PHP 5.3 and greater requires that the MySQL server is using a newer and more secure password hash. If you receive the following error:

Warning: mysql_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.

You can resolve this by logging into the database using phpMyAdmin or another MySQL client tool with that username and password, selecting the database and running the following SQL command on that database:

SET SESSION old_passwords=FALSE;
SET PASSWORD = PASSWORD('your-existing-password-in-plain-text');

Maintain peace of mind with 24/7 UK based support

Email any time or call 01480 26 00 00 014 80 26 00 00