Add the following to /etc/my.cnf:

log=/var/log/queries.log

Then restart mysqld.

All queries will be logged to that file. In MySQL 4.1 the log file must already exists beforehand. Check /var/log/mysqld.log during startup in case it’s not logging anything.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.