MySQL Bugs: #99978: Workbench ignores "others" connection options set in Advanced

Bug #99978	Workbench ignores "others" connection options set in Advanced
Submitted:	25 Jun 2020 7:39	Modified:	7 Sep 2020 12:38
Reporter:	Dimitris Vayenas	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0.20	OS:	Any (Verified in MacOS and Windows)
Assigned to:		CPU Architecture:	x86
Tags:	advanced connection, default-auth=mysql_native_password, others, SSL

Description:
When setting up a connection in non-default port (i.e. 13306) using SSL with "Require and Verify CA" option and also set up in the "others" option in the advanced tab the option: --default-auth=mysql_native_password, workbench cannot be used to import data to the server.

During import the following error appears: 
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading final connect information', system error: 0

It appears the the option --default-auth=mysql_native_password should be transmitted and during the import instruction command, yet the Workbench client fails to do so. 

How to repeat:
Setup a WP Engine account and try to connect using the credentials provided in port 13306 using SSL in "Require and Verify CA" option.

You will get connected with limited functionality. For example you will be able to select or export\dump data but when it comes to importing data then the following error occurs:

11:25:08 [ERR][wb_admin_export.py:process_db:251]: Error from task: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading final connect information', system error: 0

Suggested fix:
Following extensive debugging with the WPEngine teams in both UK & the US we came to the conclusion that, given that the user is able to perform the import via console using a command such as this:

mysql -u username  -h hostname.sftp.wpengine.com -P 13306  -p --ssl-ca=/Users/dimitrisv/wpengine_root_ca.pem --default-auth=mysql_native_password tableschema < imptest.sql --verbose  > op.log

The issue arises from the fact that, somehow, the mySQLWorkbench omits passing the option  --default-auth=mysql_native_password to the server, or it only passes it during the initial connection but it does not persists.

Screenshots of settings

Attachment: Screenshot 2020-06-25 at 10.41.13.png (image/png, text), 420.53 KiB.

Screenshots of settings

Attachment: Screenshot 2020-06-25 at 10.41.02.png (image/png, text), 367.78 KiB.

Screenshots of settings

Attachment: Screenshot 2020-06-25 at 10.41.33.png (image/png, text), 232.07 KiB.

We just realised that it works using Workbench 6.3.10 while the distribution of the target database is 5.7.29-32
Percona Server (GPL), Release '32', Revision '56bce88' - debian-linux-gnu   (x86_64)

Hello Dimitris Vayenas,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil