Personal tools

Log in

Changes

From All n One's bxp software Wixi

Jump to: navigation, search

MySQL - Setting Up ODBC and SSL

749 bytes added, 15:16, 23 October 2014
no edit summary
That should give a warning that passwords on the command line is a bad idea, but it should work.
 
 
== Step 7: Apply SSL to the ODBC connection string ==
Last step is to apply the ssl settings to the ODBC connection coming from a web server.
https://www.connectionstrings.com/mysql/
 
<code>https://www.connectionstrings.com/mysql-connector-odbc-5-1/
Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;
User=myUsername;Password=myPassword;sslca=c:\cacert.pem;
sslcert=c:\client-cert.pem;sslkey=c:\client-key.pem;sslverify=1;Option=3;
 
</code>
 
<code>https://www.connectionstrings.com/mysql-connector-odbc-3-51/
Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Database=myDataBase;
User=myUsername;Password=myPassword;sslca=c:\cacert.pem;
sslcert=c:\client-cert.pem;sslkey=c:\client-key.pem;sslverify=1;Option=3;</code>
7,528
edits