SSL is not being used to secure our connection to MySQL on Ubuntu 16.04
I have followed this tutorial here “How To Configure SSL/TLS for MySQL on Ubuntu 16.04 ” and “How To Set Up a Remote Database to Optimize Site Performance with MySQL on Ubuntu 16.04 ”.
In the log below, the haveopenssl and havessl variables read “YES”. Furthermore, the sslca, sslcert, and sslkey variables have been populated with the names of the relevant certificates that we generated:
mysql> SHOW VARIABLES LIKE ’%ssl%’;
| Variablename | Value |
| haveopenssl | YES |
| havessl | YES |
| sslca | ca.pem |
| sslcapath | |
| sslcert | server-cert.pem |
| sslcipher | |
| sslcrl | |
| sslcrlpath | |
| ssl_key | server-key.pem |
9 rows in set (0.01 sec)
However, when I check the connection details again, the specific SSL cipher is not displayed, indicating that SSL is not being used to secure our connection. See details below:
SSL: Not in use
Connection: Localhost via UNIX socket
What am I doing wrong?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.