Anonymous, bureaucrat, administrator
7,528
edits
Changes
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>