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

mysql, security, ssl

Solution

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';

Problem

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. Regards, UDAY

Original source