You need to be Payday Loans UK Why would you

Mysql log queries FreeBSD

If you want to activate logging of mysql queries, add in your my.cnf (by default it is /var/db/mysql/my.cnf)
in [mysqld] section:

log=/var/log/mysql.log

create log file:

#touch /var/log/mysql.log
#chmod 666 /var/log/mysql.log

and restart mysql-server:

#/usr/local/etc/rc.d/mysql-server restart (it can be different on you server)

That is all.

PS: I don’t recommend you use it on hight loaded servers permanently. Use it only for debugging.

Leave a Reply