Re: [MySQL][ODBC 8.0(a) Driver]Bad handshake

[Bogdan Degtyariov]

Most likely you issue comes from the fact that the MySQL ODBC 8.0 driver is trying to connect using SSL by default. The SSL connection has been made the default mode for some time in the version 8.0, this is one of the key differences comparing to the version 5.1.

You can change this behavior by disabling SSL. This can be done through the connection string by adding SSLMODE=DISABLED to your connection string. This setting will cause the driver not to try SSL. A better option would be to set SSLMODE=PREFERRED. This means the driver will try use SSL if the server is configured, otherwise it falls back to unencrypted connection.

Alternatively, the above option can be set through the GUI dialog:

Details >> SSL >> SSL Mode >> [DISABLED / PREFERRED]