Nothing I have done so far seems to work
# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 max_allowed_packet=2MB
[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid log-query=/var/log/mysql-query.log
empty
and then I added to /etc/init.d/mysqld
get_mysql_option mysqld_safe log "/var/log/mysqld-query.log" querylogfile="$result" -and- start(){ touch "$querylogfile" chown mysql:mysql "$querylogfile" chmod 0640 "$querylogfile"
but nothing is logged.
Can someone toss me a bone here?
Craig
# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 max_allowed_packet=2MB
[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid log-query=/var/log/mysql-query.log
empty
and then I added to /etc/init.d/mysqld
get_mysql_option mysqld_safe log "/var/log/mysqld-query.log" querylogfile="$result" -and- start(){ touch "$querylogfile" chown mysql:mysql "$querylogfile" chmod 0640 "$querylogfile"
but nothing is logged.
Try to put log=/var/log/mysqld.log into [mysqld] section of my.cnf
HTH Sasha