MySQL ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)

MYSQL "ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)"

Solución Fuente: http://stackoverflow.com/questions/22023387/django-mysql-python-connection-using-old-pre-4-1-1-authentication-protocol-r

http://dev.mysql.com/doc/refman/5.6/en/old-client.html


I had a 4.1 server which was still configured to generate only old passwords (16 digit) and a newer client which did not support old passwords. I could modify neither the server nor the client configuration.

On the client side, I used the following command to generate a 41-digit password:
SELECT PASSWORD('blablabla');

Then on the server side, I set the password to this 41-digit string:
SET PASSWORD FOR 'bob'@'somehost' = '*73C98624E32963F3D4828B9398FD3F67B8D58E40'

The client then connected flawlessly to the server.