I've wrestled with the same question. The only options I came up with were:
- Do as you suggest and require SSL for the account. - Inspect the 'show status' variable of Ssl_accepts after a connection attempt on an otherwise quiet mysql instance. - Sniff the traffic between client and server, but this is actually non trivial to determine if the traffic is really encrypted, especially if compression is used. If there is another method, I would be interested in hearing it as well. Regards, Paul -----Original Message----- From: Yves Goergen [mailto:[EMAIL PROTECTED] Sent: Saturday, May 20, 2006 3:17 PM To: List: MySQL Subject: How to find out about SSL connection? Hello, I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL 4.0 and 5.0 database server, both on Linux. In Query Browser, I can check the options "Use SSL if available" but how do I know if it is available and used? I couldn't find any SQL command to show me the encryption status of connections. What use has an option "SSL if you can" if I can't find out whether it actually does SSL or not... I simply require it to do and to not connect at all if it can't. -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> http://beta.unclassified.de - My web laboratory. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
