Bug #91844 windows ODBC driver 8.0 fails with SSL connection
Submitted: 31 Jul 2018 11:52 Modified: 1 Aug 2018 8:53
Reporter: Mark Salisbury Email Updates:
Status: Analyzing Impact on me:
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:8.0(w) OS:Microsoft Windows (Windows 10 Professional x64)
Assigned to: Assigned Account CPU Architecture:x86

[31 Jul 2018 11:52] Mark Salisbury
I found this bug setting up a brand new W10 pro x64 VM (on Azure) from scratch.
I used the latest version 8.0 of the MySQL drivers.
I found that I could connect to another MySQL database (remote) which did not have an SSL requirement, and I can connect to the desired DB from another machine using v5.3 drivers. 
The error is that as soon as one tests the ODBC driver, one gets:
"Lost connection to MySQL server at 'reading final connect information', system error: 2"

I removed all MySQL elements from the machine and installed v 5.3 ODBC driver, and had instant success with identical parameters.
The DB I was connecting to is a WPEngine site database, following instructions at: https://wpengine.com/support/setting-remote-database-access/ which work normally.

How to repeat:
On Windows 10 Professional download x86 ODBC MySQL connector v8.0
Add ODBC System driver: MySQL of type ANSII or unicode.
Specify a remote server which requires SSL.
add the TCP/IP address and credentials. The creds don't matter: it doesn't get that far!
Click Test.

Suggested fix:
workaround (not a fix): use a legacy version of the driver.
[3 Jan 15:53] Matt Laski
I had the exact same problems connecting to a WPEngine mysql database using SSL from MySQL Workbench v8.0.13 on Windows 10 v1803 (both the GUI and the included CLI utility).

Downgraded to MySQL Workbench v6.3.10 and immediately connected using the exact same configuration information.  

So glad I found this bug report, its been driving me crazy for a day now trying to figure out why this wasn't working.