LNMP one-click installation package cleans up mysql-bin.00001 log file method

  
                  

Q: If you comment out log-bin, mysql starts to report error /usr/local/mysql/bin/mysql -u root -p Login mysql management appears Copy content to clipboard Code: ERROR 2002 (HY000): Can' t connect to local MySQL server through socket '/tmp/mysql.sock' (2) How to solve, my log has passed 4G

Answer: /usr/local/mysql/bin/mysql -u Root -p login execution: reset master;

If you want to disable the log /etc/my.cnf comment out the #log-bin=mysql-bin #binlog_format=mixed lines

Copyright © Windows knowledge All Rights Reserved