MySQL Forums
Forum List  »  Connector/ODBC

Re: How to setup SSL connection from local mysql server to vba client using ODBC
Posted by: Bogdan Degtyariov
Date: May 10, 2017 12:45AM

Hi Tim,

MySQL Connector/ODBC uses the approach very similar to mysql command line.
You can check here what options have to be set for it:

https://dev.mysql.com/doc/refman/5.7/en/using-secure-connections.html

Please note that the ODBC options will have similar, but slightly different names:

https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html

For instance, the command line option --ssl-ca=ca-cert.pem corresponds to sslca=ca-cert.pem
You should be able to figure out easily.

Also, the SSL options can be set through the DSN Setup dialog from ODBC Driver Manager. The SSL options are available by clicking the "Details >>" button and selecting SSL tab.

On the server side it would be a good idea to grant user privileges with "REQUIRE SSL" option.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to setup SSL connection from local mysql server to vba client using ODBC
May 10, 2017 12:45AM


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.