How to close ssl in mysql

Method: 1. Use "SHOW VARIABLES LIKE'%ssl%'" to check the ssl status; 2. Modify the "my.cnf" file and add "skip_ssl" in "[mysqld]"; 3. Use "service mysqld restart" can restart mysql.

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How to turn off ssl in mysql

1. Check whether SSL is enabled:

SHOW VARIABLES LIKE '%ssl%';

##See the value of have_ssl If YES, SSL is enabled. (have_openssl indicates whether SSL is supported)

2. Modify the configuration file my.cnf and add the following content:

# disable_ssl
skip_ssl

3. Restart MySQL:

service mysqld restart

4. Check the opening status of SSL again:

See that the value of have_ssl is DISABLED, which means it is closed. SSL.

Recommended learning:

mysql video tutorial

The above is the detailed content of How to close ssl in mysql. For more information, please follow other related articles on the PHP Chinese website!