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!