Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) mysql

Set session old_passwords=0; set password for 'root'@'%' = password('lacontraseña');


Set session old_passwords=0; set password for 'usuario'@'IP' = password('lacontraseña');


Fuente: http://stackoverflow.com/questions/18017354/mysql-odbc-link-fails-due-to-authentication-protocol-refused

Fuente: https://bugs.mysql.com/bug.php?id=70023