1. Make sure the updated profile is correct. (/opt/bitnami/mysql/my.cnf not /etc/mysql/my.cnf)
root@wnlin-wordpress:/opt/bitnami/mysql# ls -la | grep my.cnf -rw-r--r-- 1 bitnami root 613 Apr 28 16:33 my.cnf
2. Added following parameters to config.
root@wnlin-wordpress:/opt/bitnami/mysql# cat my.cnf | grep log-bin log-bin
3. Change to bitnami root shell.
root@wnlin-wordpress:/opt/bitnami# ls -al | grep use -rwxr--r-- 1 root root 269 Nov 16 2015 use_wordpress
root@wnlin-wordpress:/opt/bitnami# ./use_wordpress bash-4.2# ./
4. Restart mysql.
bash-4.2# pwd /opt/bitnami bash-4.2# ./ctlscript.sh restart mysql 180428 16:27:27 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/mysqld.pid e /opt/bitnami/mysql/scripts/ctl.sh : mysql stopped 180428 16:27:31 mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'. 180428 16:27:31 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitna /opt/bitnami/mysql/scripts/ctl.sh : mysql started at port 3306
5. Make sure the log-bin settings have been applied.
mysql> SHOW BINARY LOGS; +-------------------+-----------+ | Log_name | File_size | +-------------------+-----------+ | mysqld-bin.000001 | 22385203 | +-------------------+-----------+ 1 row in set (0.00 sec)