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!