MYSQL ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)
authentication, mysql
Solution
Use this workaround for MySQLWorkBench 6.0 at the Manage Server Connections Dialog Box:
Add useLegacyAuth=1 in the Advanced options box in the connection settings dialog.
Problem
when I tried to restore all database dump which is in 5.0 version to 5.6 version, it got restored and after that when I tried to reconnect, am getting the following error `ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)`.. I have tried adding the following lines in My.ini and restarted the service,but the issue persist till. ``` skip-grant-tables ``` The following link says its a bug in MYSQL. https://github.com/santisaez/powerstack/blob/master/packages/mysql/mysql-powerstack-secure_auth.patch Do anyone have any fixes for this solution?