Bug #78060 skip-secure-auth option not added to Export/Import of data
Submitted: 13 Aug 2015 18:07 Modified: 24 Apr 2018 15:38
Reporter: Bir Grewal Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.3 OS:MacOS
Assigned to: CPU Architecture:Any

[13 Aug 2015 18:07] Bir Grewal
Description:
Previous bug report for this same issue was marked as closed without complete resolution. Bug #70023

The issue is very old but the developers haven't worked on a resolution yet.

More details can be found there Bug #70023

-------------------

--skip-secure-auth is NOT added to commands when Exporting/Importing data using MySQL Workbench for clients with option set to use 'old authentication protocol'

Basic connection for querying works from within the editor but --skip-secure-auth option is not added to commands used for Import/Export of data.

There is no workaround. One cannot use Workbench at all for this & has to use command line mysql command for import/export of DB data.

How to repeat:
Get below error for Export/Import of Db data, even with proper client option set (Connection->Advanced->Use old authentication protocol)

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

Suggested fix:
--skip-secure-auth added to commands when Exporting/Importing data using MySQL Workbench for clients with option set to use 'old authentication protocol'
[26 Aug 2015 11:32] MySQL Verification Team
Thank you for the bug report.

08:30:05 Dumping dx (t1)
Running: mysqldump.exe --defaults-file="c:\users\miguel\appdata\local\temp\tmp9kk9_r.cnf"  --set-gtid-purged=OFF --user=user --host=127.0.0.1 --protocol=tcp --port=3510 --default-character-set=utf8 --skip-triggers "dx" "t1"
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
08:30:06 Export of C:\Users\Miguel\Documents\dumps\Dump20150826-4 has finished with 1 errors
[26 Aug 2015 13:17] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=70511 marked as duplicate of this one.
[26 Aug 2015 23:46] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=74165 marked as duplicate of this one.
[26 Aug 2015 23:50] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=75138 marked as duplicate of this one.
[24 Apr 2018 15:38] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

The option to skip secure authorization is no longer available in the
advanced options that apply to data import and export operations. The
--skip-secure-auth option was removed in the MySQL 5.7 release.

Thank you for the bug report.