Changes

MySQL - Setting Up ODBC and SSL

1,192 bytes added, 15:01, 23 October 2014

no edit summary

Test again and you should get success again.

<code>

openssl verify -CAfile ca-cert.pem server-cert.pem client-cert.pem

</code>

== Step 4: Configure MySQL to use the certs ==

Open up the Workbench and edit Options File > Networking

Put a tick in ssl, ssl-ca, ssl-cert, ssl-key(for the next three include the commas when pasting in)

Put in ssl-ca "C:/MySQLSSLCert/ca-cert.pem"

Put in ssl-cert "C:/MySQLSSLCert/server-cert.pem"

Put in ssl-key "C:/MySQLSSLCert/server-key.pem"

Down the bottom of the screen it will say "Configuration File: C:\ProgramData\MySQL\MySQL Server 5.6\my.ini".

This is indeed the file you're editing but it may not be the one MySQL is using.

Open Control Panel > Administrative Tools > Services

Find the MySQL service and double click it.

In the "Path to executable" after the mysqld bit… it may have –defaults-file="D:\my.ini" which is actually the ini file.

Stop the service.

Backup D:\my.ini

Copy the ProgramData my.ini into the D:\my.ini

Restart the service.

The service should start.

Log into the workbench and run the following query.

SHOW VARIABLES LIKE '%ssl%';

Have_openssl = Yes

Have_ssl = Yes

ssl-ca "C:/MySQLSSLCert/ca-cert.pem"

ssl-cert "C:/MySQLSSLCert/server-cert.pem"

ssl-key "C:/MySQLSSLCert/server-key.pem"

This means that SSL is now an optional connection type.

7,528

edits