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

[25 Jun 7:39] Dimitris Vayenas
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.
[25 Jun 7:43] Dimitris Vayenas
Screenshots of settings

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

[25 Jun 7:44] Dimitris Vayenas
Screenshots of settings

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

[25 Jun 7:44] Dimitris Vayenas
Screenshots of settings

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

[25 Jun 11:50] Dimitris Vayenas
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)