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’);