I need to set up ODBC connection to MySql. How do i set up SSL?

October 28, 2016 150 views
MySQL Ubuntu

I am trying to connect to my database server with an application that will connect through an ODBC connection. To set up the ODBC connection I need to use SSL. How do I set that up?

1 Answer

Hello.

Do you have set up SSL on your MySQL installation?
If not you should do it to use MySQL over SSL.
MySQL docs have tutorial for doing so:
Generating OpenSSL certs.
Setting Up SSL with MySQL.

In case this is already done, you need to provide certs to ODBC setup.
You can learn how to do it in MySQL ODBC guide. It will explain you how and what's needed to do so.

  • My only connection is through putty using SSH. I use it to access the terminal on the event to server as well as 2 use my sequel workbench from a remote computer I was thinking that the SSH wood also allow me to use odbc however from what I read I need to setup SSL. I will read the articles hopefully that is exactly what I need.

    • Well, maybe you don't need SSL. Please keep in mind that SSL and SSH are not so same. Yes, on low level they can be. E.g. for SSH you use key authentication while for SSL you need certs.

      You can read Connecting to MySQL Remotely from Windows with SSH - MySQL docs. Not so descriptive tutorial but can show you how to use SSH and ODBC.

      • Well, I need the odbc connection to connect a program that some unsophisticated end-users will end up using. I have succeeded in setting up the program using SSH however it requires launching putty to run and I would rather the end-user be able to Simply open the program without having to open the SSH connection beforehand. I think the SSL will be the way to go because then the connection to the database is handled in the background by the software.

Have another answer? Share your knowledge.