MySQL Check if the running Mysqld server supports OpenSSL

1. Background of the problem

Using SSL connections between MySQL server and client, you need to determine if the system supports OpenSSL, and how to check if OpenSSL is supported

2. Solutions

Execute queries using MySQL's own commands

SHOW VARIABLES like  ' Have_openssl ';

3. Implementation results

If value is "Yes", OpenSSL is supported, but the query result is "DISABLED", which indicates that OpenSSL is not supported

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

MySQL Check if the running Mysqld server supports OpenSSL