How to disable MySQL binlog on Ubuntu?

peng·2025년 4월 29일

Terminal

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

sudo service mysql restart

sudo mysql -u root -p

sudo rm -rf /var/lib/mysql/binlog.*

/etc/mysql/mysql.conf.d/mysqld.cnf

...
disable_log_bin
...

MySQL Client

SHOW VARIABLES LIKE 'log_bin';

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | OFF   |
+---------------+-------+
1 row in set (0.01 sec)

0개의 댓글