There’re 2 ways to enable mysql query logs
in /etc/my.cnf
log=/var/log/mysqld-query.log
or add ” –log” in start script
/usr/bin/mysqld_safe –datadir=”$datadir” …. –log >/dev/null 2>&1 &
How to stop binary log
remove the following from my.cnf
log-bin=mysql-bin
binlog_format=mixed