MySQL Forums
Forum List  »  Connector/ODBC

Re: [MySQL][ODBC 8.0(a) Driver]Bad handshake
Posted by: Bogdan Degtyariov
Date: October 07, 2019 03:24AM

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]

Options: ReplyQuote

Written By
Re: [MySQL][ODBC 8.0(a) Driver]Bad handshake
October 07, 2019 03:24AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.