Bug #70962 Connection using old (pre-4.1.1) authentication protocol refused ...

• Submitted: 20 Nov 2013 14:24
• Modified: 31 Dec 2013 4:24
• Reporter: ANDREA LANFRANCHI
• Status: Duplicate
• Category: MySQL Workbench: Migration
• Severity: S1 (Critical)
• Version: 6.0.8.11354
• OS: Windows (Windows 8 64bit)
• CPU Architecture: Any

[20 Nov 2013 14:24] ANDREA LANFRANCHI

Description:
The Bulk Data Transfer procedure fails due to errors like theese:

15:12:04 [ERR][      copytable]: Failed opening connection to MySQL: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
15:12:04 [ERR][      copytable]: Exception: mysql_real_connect: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

Note that "Use the old authentication protocol" is enabled (ticked) on both connections (target and source).

How to repeat:
Reproduce always using Database Migration Wizard among two connections which require the configured user to log in with the "old" authentication protocol.

[5 Dec 2013 19:28] Alfredo Kojima

Have you tried resetting the MySQL user password (same password, but set again)?

[6 Dec 2013 10:44] ANDREA LANFRANCHI

I do not konw how this could be relevant. All steps *before* effective data migration work well with "Use Old Authentication Protocol" enabled. At the step where the wizard really begins to copy data the procedure stops with the error depicted above.

This, IMHO, means that not all the steps of the wizard do read the connection settings set for target and source at the very beginning or the raw copy data step is not configured to support "Old Authentication Protocol".

[31 Dec 2013 4:24] MySQL Verification Team

Duplicate of bug #70511

[29 Mar 2014 9:32] Patrick Lauwaerts

Same problem with version 6.0.9.11421 build 1170