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)

Other Posts

• Block Paltalk Ads (and Others) via Hosts file
• E: Sub-process /usr/bin/dpkg returned an error code (2)
• How to Validate JSON in PHP
• The program can’t start because VCRUNTIME140.DLL is missing
• PHP CURL Download Remote URL to File
• PHP Check if a file was modified more than 1 hour ago
• Linux -bash: Input/output error or -bash: Read-only file system
• Dropzone.js: Drag’n’Drop File Uploads with Image Previews

Updated Posts

• Lost connection during Debian apt-get upgrade
• Bootstrap 3 Navbar with Logo Image
• Redis HMGET, HGETALL, HSET, HGET Benchmark
• PHP GetHostByName() Slow? Make it Faster
• Use Timestamp with new DateTime() in PHP
• Calculate Elapsed Time Between Two Dates in PHP
• PHP Display Date Same as Server HTTP Headers Date
• PHP cURL Download Size Limit