Aug 25, 2018

[HDGEM] How to check MySQL connection is using SSL or not ?

A client can determine whether the current connection with the server uses SSL by checking the value of the Ssl_cipher status variable. The value is nonempty if SSL is used, and empty otherwise. For example:
mysql> SHOW STATUS LIKE 'Ssl_cipher';
+---------------+--------------------+  | Variable_name | Value              |  +---------------+--------------------+  | Ssl_cipher    | DHE-RSA-AES256-SHA |  +---------------+--------------------+  1 row in set (0.00 sec)
For the mysql client, an alternative is to use the STATUS or \s command and check the SSL line:
mysql> \s  ...  SSL: Cipher in use is DHE-RSA-AES256-SHA  ...  Or:  mysql> \s  ...  SSL: Not in use  ...

Posted By Blogger to HDGEM at 8/23/2016 12:27:00 PM