client option ‘secure_auth’ enabled

When connecting from MySQL Workbench, you may get this error. This has to do with password formatting between versions of MySQL. You can work around this in the workbench, by opening the connection

Connection -> Advanced Tab -> "Use The Old Authentication Protocol"

It's may also be  possible to add the option useLegacyAuth=1 as described in this site.

When you get the same error with a Windows ODBC connection, there is no similar work around. You must manually set the users password to the older format with the following sql statements.

set old_passwords=0;
set password for 'some-account'@'192.168.1.2' = password('thePlainTextPassword'); 

Comments