Bug #69492 Cannot Connect error when using legacy authentication

• Submitted: 17 Jun 2013 12:46
• Modified: 9 Jan 2015 7:47
• Reporter: Alex Whitman
• Status: Closed
• Category: Connector / C++
• Severity: S2 (Serious)
• Version: 6.0.2 beta 1
• OS: Windows (7)
• CPU Architecture: Any

[17 Jun 2013 12:46] Alex Whitman

Description:
When trying to connect to an older MySQL server which uses legacy authentication, an error dialogue pops stating "Cannot Connect".

How to repeat:
Try to connect to a server using legacy authentication.

Suggested fix:
Allow legacy authentication.

[17 Jun 2013 12:47] Alex Whitman

Screenshot of error dialogue

Attachment: wb.png (image/png, text), 30.86 KiB.

[17 Jun 2013 12:49] Alfredo Kojima

Thank you for the bug report.

[4 Sep 2013 11:09] Steve Kimpton

I had this problem in 6.0.6 and found a near fix on one of the forums.

From the home page: 
right click on the database button, 
choose Edit connection, 
Click Advanced
Add useLegacyAuth=1 to the bottom of the 'Others' box

The reason it's only a near fix is the error persists when trying to use data export.

[22 Jul 2014 14:08] Paul DuBois

Noted in Connector/C++ 1.1.4 changelog.

Connector/C++ now supports the a useLegacyAuth connection option,
which corresponds to the MYSQL_SECURE_AUTH option for
mysql_options().