Home > Database > Mysql Tutorial > How to close ssl in mysql

How to close ssl in mysql

WBOY
Release: 2022-04-06 15:18:53
Original
11933 people have browsed it

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.

How to close ssl in 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%';
Copy after login

How to close ssl in mysql

##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
Copy after login

3. Restart MySQL:

service mysqld restart

4. Check the opening status of SSL again:

How to close ssl in mysql

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template