How to turn off MYSQL logging and disable mysql-bin.0000X files

If you enable logging in your MYSQL installation, it will take up a lot of space, and may even use up all your space. This is very scary, and all this happens quietly, and you can't feel it at all...

The mysql-bin.0000X file is usually in the var directory of the MYSQL installation folder. Mine is /usr/local/mysql/var/. If yours is not here, then look for it...

Okay, let me provide a solution. First, open the /etc/my.cnf file and find the following content. It should be noted that the two lines of log-bin and binlog_format are not together, so comment them out.
log-bin=mysql-bin
binlog_format=mixed
The comment method is very simple. Just add a # symbol in front of them, and then delete the log file of mysql-bin.0000X.
Then execute this command
/usr/local/mysql/bin/mysql -u root -p
Enter the password and log in, then execute the reset master command. If successful, no information will be returned. If failed, a prompt will appear. This solves the problem!

via: http://etsc.xujc.com/jsb/JSFW/ShowArticle.asp?ArticleID=445