Bug #71424 Exception: mysql_real_connect: Connection using old (pre-4.1.1) authentication p

• Submitted: 20 Jan 2014 8:59
• Modified: 12 Mar 2014 15:20
• Reporter: John Page
• Status: No Feedback
• Category: MySQL Workbench: Migration
• Severity: S1 (Critical)
• Version: 6.0.8.11354 build 833
• OS: Windows
• CPU Architecture: Any

[20 Jan 2014 8:59] John Page

Description:
It appears that wbcopytables.exe is not reading the setting of the "Use the old authentication protocol" option on the advanced tab, because the connection verifies and obviously works all the way up to the actual copy and the error messages all reference wbcopytables.exe.

How to repeat:
setup a MySQL server in such a way that it can only be accessed from Workbench if the "Use the old authentication protocol" is checked. Then attempt to migrate a table to the server and it will all work correctly up until the actual data transfer at which time the following error will be an generated by wbcopytables.exe : Exception: mysql_real_connect: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

[12 Feb 2014 15:20] Alfredo Kojima

Have you tried resetting the password for the account? If you reset the password (you can use the same password), the error should be permanently gone for anything connecting with that account.

[13 Mar 2014 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".