Mysql – What to do when MySQL is not generating any logs at all on Debian

debianlogsMySQL

The problem I'm having is that MySQL (5.5.46-0+deb7u1) is not generating log files. This on Debian Wheezy.

The my.cfg file has been updated according to the required config for logging ALL queries (as per http://www.microhowto.info/howto/log_all_queries_to_a_mysql_server.html). It's not writing to the specified location, nor to the default location.

Mysql errors are also not being logged, as far as I can tell.

EDIT: my.cnf is here: http://pastie.org/private/q9vwgihslpenc94mxmyyiw

EDIT: Here's the output of "show variables like '%warn%';":

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_warnings  | 1     |
| sql_warnings  | OFF   |
| warning_count | 0     |
+---------------+-------+

Best Answer

Thanks to commenters for their insights. The solutions was:

  1. Add "log_errors = /var/log/mysql/mysql.err" to my.cnf
  2. See permissions error in error log
  3. chmod log files to "mysql:root"
Related Question