Geek asks and answers

Mysql: How can I find out if my mysql supports ssl file or not?

I am trying to protect my real-time protected db servers. I read it as if we could enable ssl in mysql to make data transfer over the network between master and slave for encryption.

Can anyone help how I can find out if I have ssl support or not. If I have, how can I enable this, since I cannot compile the binary with --have-ssl

Thanks in advance. Sincerely, Uday

+3
source share
2 answers

Try starting MySQL with the option --ssl:

mysqld --ssl --help

If the server does not support SSL, you will see an error message:

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

On a running server, you can check the variables have_sslor have_openssl:

mysql> SHOW VARIABLES LIKE 'have_ssl';
mysql> SHOW VARIABLES LIKE 'have_openssl';
+5

@BluesRockAddict, ...

SSL- .

mysql> SHOW VARIABLES LIKE 'SSL%';

SSL , MySql. , have_ssl have_openssl ENABLED, , openssl.

View SSL paths.

ssl , MySql. , , SSL MySQL. , have_ssl have_openssl ENABLED.

, SSL.

mysql> \s

...

SSL:         Not in use

View if SSL is in use.

+1

More articles:


All Articles