" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi
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.
Mail (will not be published) (required)
Enter Captcha Code *
− 4 = one
Burn Ignorance is a knowledge initiative by Mindfire Solutions
Subscribe to our mailing list to get the updates to your email inbox...