Q. What do I need to use SSL-encrypted connections?
A. There are a lot of Windows versions of OpenSSL binaries compiled by different people, and some of them may cause problems when using them with DAC for MySQL.
We've tested DAC for MySQL with binaries downloaded from http://www.openssl.org/related/binaries.html.
To make DAC for MySQL use SSL-encrypted connections you should do the following:
1. Setup SSLKey and SSLCert properties of TMySQLDatabase component
2. Put DLLs downloaded from OpenSSL.org near your application EXE file.
Please note:
Your MySQL server must support SSL connections. To check if running MySQL server supports SSL, examine the value of the have_openssl system variable:
mysql> SHOW VARIABLES LIKE 'have_openssl';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_openssl | YES |
+---------------+-------+
If the value is YES, the server supports SSL connections.
If the value is DISABLED, the server supports SSL connections, but it was not started with the appropriate --ssl-xxx option.
If the value is NO, the server does not support SSL connections.