How to close the log in mysql

Mysql method to close the log: 1. Find the two codes "log-bin=mysql-bin" and "binlog_format=mixed" in the mysql configuration file; 2. Add before the two codes found "#", comment out the two lines of code; 3. Restart the MySql service.

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

How to close the log in mysql

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

***注释前请务必先停止MySQL***
/etc/init.d/mysql stop
然后在my.cnf注释下面两行(前面加#即可)
log-bin=mysql-bin
binlog_format=mixed
完成后重启MySQL
/etc/init.d/mysql restart

After the comments are completed:

#log-bin=mysql-bin
#binlog_format=mixed

[Related recommendations: mysql video tutorial]

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