I have configured my server to allow SSL, and have modified my client ~/.my.cnf so I use SSL:
[client]
ssl
ssl-cipher=DHE-RSA-AES256-SHA
ssl-ca=~/certs/ca-cert.pem
When I log in with my client and view the status, it lists a cipher on the SSL line:
mysql> \s
--------------
SSL: Cipher in use is DHE-RSA-AES256-SHA
Without installing something like wireshark to verify that the connection is secure, can I assume that I'm connecting via SSL based on this information?
Best Answer
From the client, just run
status
. If this connection is using SSL, you'll get something interesting in the SSL row.If this connection is not using SSL, you'll get:
You can also use:
But I think the first is more attractive, and sure easier to type.