Related

Product Now Available: Managed MySQL Databases Product
Slow phpMyAdmin/MySQL import Question Question
How does one fix this MySQL zero day vulnerability on Ubuntu 14.04? Question Question

Question

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

Posted October 28, 2016 6.9k views
UbuntuMySQL

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?

Add a comment
amartine00eba94
By:
amartine00eba94

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer
xMudrii October 28, 2016

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.

Reply Report
  • amartine00eba94 October 28, 2016

    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.

    Reply Report
    • xMudrii October 28, 2016

      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.

      Reply Report
      • amartine00eba94 October 29, 2016

        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.

        Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help