I need to be able to examine the queries being sent to MySQL.  After reading
the documentation I created /etc/my.cnf and added a line for the log option.
Unfortunately, I have been unable to get it to log the queries.  
 
Is there another option that must be set?
 
I have the following in /etc/my.cnf
 
[mysqld]
log=/var/log/mysql/mysql_query.log
[mysql.server]
log=/var/log/mysql/mysql_query.log
 
This is what /var/log/mysql/mysql_query.log looks like.  
 
/usr/sbin/mysqld, Version: 4.0.13-log, started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
 
I am using MySQL 4.0.13 on Redhat 7.3.
Aaron
 
 

Reply via email to