Question
How can I check if my MySQL server is configured to use TLS/SSL?
Asked by: USER7388
64 Viewed
64 Answers
Answer (64)
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.