Bug #74165 Use the old authentication protocol setting ignored for data exports
Submitted: 30 Sep 2014 21:35 Modified: 26 Aug 2015 23:44
Reporter: Madhu Lundquist Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.2.3 OS:Windows (Microsoft Windows 7 Professional Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[30 Sep 2014 21:35] Madhu Lundquist
Description:
If you have enabled the old authentication protocol for a connection and then you attempt to export data, you get the following error:

11:30:49 Dumping ********(********)
Running: mysqldump.exe --defaults-file="c:\users\********\appdata\local\temp\********.cnf"  --set-gtid-purged=OFF --user=******** --max_allowed_packet=1G --host=******** --port=3306 --default-character-set=utf8 "********"
mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connect

Operation failed with exitcode 2
11:30:51 Export of ******** has finished with 1 errors

How to repeat:
Create connection for server that requires old authentication protocol and then attempt to export data.
[10 Oct 2014 12:30] Daniƫl van Eeden
This might be a duplicate of Bug #73331
[15 Oct 2014 5:53] Alfredo Kojima
This is a missing feature in mysqldump, your best bet is to reset the password in the server (can be the same one)
[26 Aug 2015 23:44] MySQL Verification Team
Duplicate of http://bugs.mysql.com/bug.php?id=78060 already verified.