Published by exdone
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.