How can I log all MySQL queries?

Answer:

In MySQL, run the following commands:

SET global log_output = 'FILE';
SET global general_log_file='/var/log/mysql/query.log';
SET global general_log = 1;

(you have to make sure the /var/log/mysql/query.log exists and use:

chown mysql:adm query.log

To turn off logging:

SET global general_log = 0;