How to disable binary logging in MySQL/MariaDB

Introduction

When binary logging is enabled, MySQL/MariaDB can consume a lot of available disk space with log files. This article provides the steps to disable binary logging.

Procedure

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Open /etc/my.cnf in your preferred text editor.
3. Add the following line under [mysqld].

   disable-log-bin=1

4. Save the changes and exit the text editor.
5. Restart the SQL service.

   /scripts/restartsrv_mysql

Additional resources

Binary Logging Options and Variables