LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   How do I Active MySQL Query Log? (https://www.linuxquestions.org/questions/linux-server-73/how-do-i-active-mysql-query-log-650877/)

FredJones 06-22-2008 09:00 AM

How do I Active MySQL Query Log?
 
I need to active the MySQL query log on:

Server version: 5.0.45 Source distribution

I tried editing

/etc/my.cnf

and mine now looks like:

Code:

[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
wait_timeout=1800
max_connections=150
connect_timeout=10

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log=/var/log/mysqld.log
log-output = FILE,TABLE

and of course I ran:

Code:

service mysqld restart

but when I view /var/log/mysqld.log I just see startup/shutdown things, but no queries. Can anyone point me in the right direction to get the query log turned on?

Thanks!

XavierP 06-22-2008 09:24 AM

http://publib.boulder.ibm.com/infoce...nablelogs.html seems to have a few more things enabled than in your my.cnf file. Try adding them and restarting the logging and post back the results.

FredJones 06-22-2008 01:41 PM

Doesn't seem to help. :(


All times are GMT -5. The time now is 12:23 AM.