To use encrypted connections between the MySQL server and client programs, your system must support OpenSSL.
If you compile MySQL from a source distribution, CMake configures the distribution to use the installed OpenSSL library by default.
To compile using OpenSSL, use this procedure:
Ensure that OpenSSL 1.0.1 or higher is installed on your system. If the installed OpenSSL version is lower than 1.0.1, CMake produces an error at MySQL configuration time. If it is necessary to obtain OpenSSL, visit http://www.openssl.org.
WITH_SSLCMake option determines which SSL library to use for compiling MySQL (see Section 2.9.4, “MySQL Source-Configuration Options”). The default is
-DWITH_SSL=system, which uses OpenSSL. To make this explicit, specify that option on the CMake command line. For example:
cmake . -DWITH_SSL=system
That command configures the distribution to use the installed OpenSSL library. Alternatively, to explicitly specify the path name to the OpenSSL installation, use the following syntax. This can be useful if you have multiple versions of OpenSSL installed, to prevent CMake from choosing the wrong one:
cmake . -DWITH_SSL=path_name
Compile and install the distribution.
mysql> SHOW VARIABLES LIKE 'have_ssl'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | have_ssl | YES | +---------------+-------+
If the value is
YES, the server supports
encrypted connections. If the value is
DISABLED, the server is capable of supporting
encrypted connections but was not started with the appropriate
--ssl- options to
enable encrypted connections to be used; see
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”.