Shulou(Shulou.com)05/31 Report--

This article is about how mysql shuts down the log. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Mysql closes the log: 1, find "log-bin=mysql-bin" and "binlog_format=mixed" in the mysql configuration file; 2, add "#" before the two found code, comment out the two codes; 3, restart the MySql service.

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

Find the configuration file for MySql and comment on the following two lines (that is, add the # symbol at the beginning of the line). Then restart the MySql service

* before commenting, be sure to stop MySQL***/etc/init.d/mysql stop and then restart MySQL/etc/init.d/mysql restart after the following two lines of my.cnf comment (preceded by #) log-bin=mysql-binbinlog_format=mixed is complete.

After the comments are completed:

# log-bin=mysql-bin#binlog_format=mixed Thank you for reading! This is the end of the article on "how to close the mysql log". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.