Disable MySQL bin log on Bitnami

if you have cloud sevrer with less disk space, it is better disable MySQL bin log as it take approx 3 GB of disk space on bitnami server.

To disable MySQL binlog, edit mysql config file.

vi /opt/bitnami/mysql/my.cnf

Find

[mysqld]

Add below

disable_log_bin

Here is what i have in the my.cnf

root@wordpress-vm:~# cat /opt/bitnami/mysql/my.cnf

[mysqladmin]
user=root

[mysqld]
disable_log_bin
basedir=/opt/bitnami/mysql
datadir="/opt/bitnami/mysql/data"
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
tmpdir=/opt/bitnami/mysql/tmp
max_allowed_packet=32M
bind-address=127.0.0.1
skip-name-resolve=1
default-authentication-plugin=mysql_native_password

character-set-server=UTF8
collation-server=utf8_general_ci
[client]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock

default-character-set=UTF8
[manager]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
pid-file=/opt/bitnami/mysql/tmp/manager.pid
default-mysqld-path=/opt/bitnami/mysql/bin/mysqld.bin


!include /opt/bitnami/mysql/bitnami/my.cnf
root@wordpress-vm:~# 

Now restart MySQL

/opt/bitnami/ctlscript.sh stop mysql
/opt/bitnami/ctlscript.sh start mysql

You can now remove the file starting with binlog from folder /opt/bitnami/mysql/data

rm -f /opt/bitnami/mysql/data/binlog.*