{"id":626,"date":"2018-02-01T11:11:11","date_gmt":"2018-02-01T18:11:11","guid":{"rendered":"http:\/\/layne.shipley.website\/?p=626"},"modified":"2018-02-01T11:11:11","modified_gmt":"2018-02-01T18:11:11","slug":"connecting-mysql-odbc-to-use-ssl-certificates","status":"publish","type":"post","link":"https:\/\/layne.eqlik.us\/index.php\/archives\/626","title":{"rendered":"Connecting MySQL ODBC to Use SSL Certificates"},"content":{"rendered":"<h3><a href=\"https:\/\/www.connectionstrings.com\/mysql-connector-odbc-5-1\/using-ssl\/\">Using SSL<\/a><\/h3>\n<p><code><span class=\"key\">Driver<\/span>=<span class=\"value\">{MySQL ODBC 5.1 Driver};<\/span><span class=\"key\">Server<\/span>=<span class=\"value\">myServerAddress;<\/span><span class=\"key\">Database<\/span>=<span class=\"value\">myDataBase;<\/span><span class=\"key\"><br \/>\nUser<\/span>=<span class=\"value\">myUsername;<\/span><span class=\"key\">Password<\/span>=<span class=\"value\">myPassword;<\/span><span class=\"key\">sslca<\/span>=<span class=\"value\">c:\\cacert.pem;<\/span><span class=\"key\"><br \/>\nsslcert<\/span>=<span class=\"value\">c:\\client-cert.pem;<\/span><span class=\"key\">sslkey<\/span>=<span class=\"value\">c:\\client-key.pem;<\/span><span class=\"key\">sslverify<\/span>=<span class=\"value\">1;<\/span><span class=\"key\">Option<\/span>=<span class=\"value\">3;<\/span><\/code><\/p>\n<div class=\"comments-and-tags-container\">\n<div class=\"comments\">\n<p>SSLCA specifies the path to a file with a list of trust SSL CAs<\/p>\n<p>SSLCERT specifies the name of the SSL certificate file to use for establishing a secure connection.<\/p>\n<p>SSLKEY specifies the name of the SSL key file to use for establishing a secure connection.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Using SSL 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; SSLCA specifies the path to a file with a list of trust SSL CAs SSLCERT specifies the name of the SSL certificate file to use for establishing a secure connection. SSLKEY specifies the name of the SSL key file to use for establishing a secure connection.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[49,50],"class_list":["post-626","post","type-post","status-publish","format-standard","hentry","category-general","tag-mysql","tag-odbc"],"acf":[],"_links":{"self":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/comments?post=626"}],"version-history":[{"count":0,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/626\/revisions"}],"wp:attachment":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/media?parent=626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/categories?post=626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/tags?post=626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}