Mysql

Mysql Log

to enable the query log, put this in /etc/my.cnf in the [mysqld] section

log   = /path/to/query.log

remember that this logfile can grow very big on a busy server

update:

as of mysql 5.1.12 you should use

general_log=1

with mysql 5.1.29, the log option is deprecated. to specify the logfile use

general_log_file=/path/to/query.log

instead. See http://dev.mysql.com/doc/refman/5.1/en/query-log.html