Disable MySQL Binary Logging (Turn Off Log_Bin Variable)

Posted on October 7, 2018 at 2:30 pm

You can disable MySQL binary logging by adding this line to /etc/mysql/my.cnf:

skip-log-bin

Make sure to add it below [mysqld] section.

Then restart MySQL service like this:

/etc/init.d/mysql restart

To verify binary loggin is disabled, login to MySQL as root and type:

SHOW VARIABLES LIKE "log_bin";

The result should be like this:

MariaDB [(none)]> SHOW VARIABLES LIKE "log_bin";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | OFF   |
+---------------+-------+
1 row in set (0.001 sec)

Receive updates via email

Other Posts

Updated Posts