Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Can't Connect to MySQL version 5.0.77

RyanSmith
6 - Meteoroid

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:

 

Capture.JPG

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!

 

 

1 REPLY 1
KevinP
Alteryx Alumni (Retired)

@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-ref...

Labels