Contents
Can a client connect to MySQL using ODBC?
We’ve got a client application that connects to our online MySQL database (5.1.44-community-log) thru a ODBC connector (the server is a managed* dedicated webserver). This works very nice. However I can’t get it to work using SSL.
Is the ODBC connector compatible with SSL access?
I have verified it is SSL several ways. I have used the previous versions of the ODBC connector for a long time with SSL. I recently moved our database to a new server, used new MySQL 8, made new users, etc. So I set up my access with Workbench again, works well.
How to disable default SSL connection in MySQL?
Disable the default requirement to use SSL for connections to server. When set to “0” [default], Connector/ODBC tries to connect with SSL first, and falls back to unencrypted connection if it is not possible to establish an SSL connection.
When to use unencrypted connection in ODBC?
When set to “0” [default], Connector/ODBC tries to connect with SSL first, and falls back to unencrypted connection if it is not possible to establish an SSL connection. When set to “1,” Connection with SSL is not attempted, and unencrypted connection is used, unless SSL_ENFORCE is also set to “1.”
How to configure MySQL server to use SSL?
Create the directory to store the SSL keys. Create the SSL keys. Edit the MySQL configuration. Test the SSL configuration. Create a user and allow remote access. Test the remote MySQL connection. This document describes how to configure your server to use SSL for MySQL® database connections.
How to connect to MySQL server using sqldriverconnect?
You can connect to the MySQL server using SQLDriverConnect, by specifying the DRIVER name field. Here are the connection strings for Connector/ODBC using DSN-less connections: For Connector/ODBC 8.0: ConnectionString = “DRIVER= {MySQL ODBC 8.0 Driver}; SERVER=localhost; DATABASE=test; USER=venu; PASSWORD=venu; OPTION=3;”
How to build a connection string for ODBC driver?
To build and test the connection string for your ODBC driver on your own computer, you can use the ODBC Data Source Administrator applet in the Control Panel. Create a File DSN for your connection, then copy settings out of the File DSN to assemble the connection string.