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:
- Setup SSLKey and SSLCert properties of TmySQLDatabase component
- 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. |
Questions list