How can I check if my MySQL server is configured to use TLS/SSL?

Responsive Ad Header

Question

Grade: Education Subject: Support
How can I check if my MySQL server is configured to use TLS/SSL?
Asked by:
64 Viewed 64 Answers

Answer (64)

Best Answer
(429)
You can connect to the MySQL server using the MySQL client and run the following query: `SHOW VARIABLES LIKE 'have_ssl';`. If the value of `have_ssl` is 'YES', the server is compiled with SSL support. Then, check `SHOW VARIABLES LIKE 'ssl_cipher';` to see if SSL is actually enabled and configured. Also, check `SHOW VARIABLES LIKE 'ssl_ca_file';` and `SHOW VARIABLES LIKE 'ssl_cert_file';` to see if certificate paths are set.