Can't Connect to MySQL version 5.0.77

Question

Hi all,

I'm trying to set up a connection to an older version (5.0.77) of MySQL database and I'm receiving the following error:

The problem is that I have no way to set secure_auth = OFF.  This is what I found about the issue: https://bugs.mysql.com/bug.php?id=71234

Anybody have a solution?  Thanks!

KevinP · Accepted Answer

@RyanSmith Thank you for your post. Please note that we only support MySQL 5.1 and higher. Please see our online help page for MySQL at: https://help.alteryx.com/10.6/index.htm#DataSources/MySQL.htm for details.

That being said the error message you are getting is because the user account in MySQL has it's password stored using a legacy password hashing method. As this method of hashing passwords has been obsolete for some time newer MySQL ODBC drivers no longer support this legacy method. To correct the error you can either have your DBA update the user account's password to use the current method of hashing passwords, or you can try an ODBC driver version thats supports this password hashing method. You can find details regarding both possible solutions in the following StackOverflow post: http://stackoverflow.com/questions/18017354/mysql-odbc-link-fails-due-to-authentication-protocol-refused