Mysql query log not working

Question

I have a problem with the mysql query-log.

I searched the used my.cnf with https://stackoverflow.com/a/2896718/1012683 and added the line log=/var/log/mysqld_query.log to my.cnf. Then I restartet mysql but there is still no query-log.

Whats wrong here?

Thanks, Flo

score 21 · Accepted Answer · edited Jan 11 '14 at 03:01

21

You need to set general_log to 'ON'. see here

Add this in my.cnf and then restart MySQL server:

general_log = 1
log=/var/log/mysqld_query.log

or

SET GLOBAL general_log = 'ON';

edited Jan 11 '14 at 03:01

stovroz

6,835
2
48
59

answered Aug 08 '12 at 09:14

Omesh

27,801
6
42
51

it works! i've done SET GLOBAL general_log = 'ON' and SET GLOBAL general_log_file = '/var/log/mysqld_query.log' – sbo Aug 08 '12 at 09:32
where is my my.cnf? http://stackoverflow.com/questions/2482234/how-to-know-mysql-my-cnf-location – thicolares Jul 29 '15 at 12:51

score 3 · Answer 2 · answered Oct 08 '12 at 12:06

You can check whether the general_log is 'ON' or 'OFF' first using query:

mysql>show variables like '%log%';

if the general_log is 'OFF', then the setting of log=... will not work. The general_log can be turn on when mysql is running (do not need to restart mysql) using cmd below:

mysql>SET GLOBAL general_log = 'ON';

And the log file in variable general_log_file will be auto generated.

Mysql query log not working

2 Answers2