Here is a query to test whether the ODBC connection to MySQL database using SSL certificates is securely done.

Even if, in the ODBC manager we set the SSL certificates in the details tab,to confirm that the connection is securely done we can use the following query :

[query] "show status like 'Ssl_cipher'" [query]

When the connection is secure the above query will return an encrypted value , something like ..DAE-RSA-AQS256-DHA but for un-secure option , it will return NULL.