Mysql – mysqlnd cannot connect to MySQL 4.1+ using old authentication

Published by

Posted on August 09, 2010

– packet 6 bytes shorter than expected in
– Client does not support authentication protocol requested
by server; consider upgrading MySQL client

Error: This means you are connecting to a mysql server using the new hash client while the server is setup to receive the old.

You will first need to make sure old-password is not enabled in my.cnf

You can just had a # in front of it to comment the settings. Restart the service and do
SET PASSWORD FOR ‘some_user’@’some_host’ = PASSWORD(‘newpwd’);

This will give you a 41 byte hash , you may want to re-enable the old-password option for legacy apps.

support authentication

Password Hashing in MySQL