Uday Uday - 1 year ago 78
MySQL Question

Mysql: How can i know whether my mysql binary has ssl support or not

I am trying to secure my db servers secured on the live setup. I have read it like we can enable ssl in mysql to make the data transfer over the network between master and slave to be encrypted.

Shall someone help on how can i know whether i have the ssl support or not. If i have how can i enable this as i cant compile a binary again with --have-ssl

Thanks in advance.

Answer Source

Try starting MySQL with --ssl option:

mysqld --ssl --help

If the server does not support SSL, you'll see an error:

[ERROR] mysqld: unknown option '--ssl'

On running server, you can check have_ssl or have_openssl variables:

mysql> SHOW VARIABLES LIKE 'have_ssl';
mysql> SHOW VARIABLES LIKE 'have_openssl';
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download