Encrypted connection in MySQL

AXISHK
AXISHK used Ask the Experts™
on
Where can I check in MySQL to ensure any sql connection is encrypted ? As a internal security audit, I am told to provide evidence to ensure that client and server connection is encrypted.

Tks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Associate Principal Engineer
Top Expert 2014
Commented:
Hello,

When logged in to the MySQL instance, you can issue the query
 
 show status like 'Ssl_cipher';
 

If your connection is not encrypted, the result will be blank :

Otherwise, it would show a non-zero length string for the cypher in use

 Variable_name | Value              |
 +---------------+--------------------+
 | Ssl_cipher    | DHE-RSA-AES256-SHA

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial