Red Bridge Internet is a San Francisco WordPress Consulting firm specializing in WordPress websites and WordPress Plugin Development. We're the ones you have been searching for.
Browse: Home / Blog / How To / How to Add MySQL Access Logs

How to Add MySQL Access Logs

By Ed Reckers on February 21, 2008

In most versions of Linux edit the file:

/etc/my.cnf

Anywhere under [mysqld] add the line:

log-error=/var/log/mysqld.log

If log file doesn’t yet exists add and set permissions:

touch /var/log/mysqld.log
chown mysql:mysql /var/log/mysqld.log

Restart MySQL in:

cd /etc/rc.d/init.d
./mysqld restart

Incoming search terms:

  • mysql access log
  • mysql log access
  • mysql access logs
  • access log mysql
  • access log to mysql
  • mysql access logging
  • MYSQL ACCES LOG
  • mysql logs access
  • how to log mysql access
  • log access mysql

Related posts:

  1. How to Check MySQL Version on Command Line
  2. Multi-Level User Access With Joomla
  3. MySQL Search Across Columns with Concat
  4. Working with MySQL SET Data Type
  5. Experts Exchange and Other Web Access Issues

Posted in | 1 Response

One response to “How to Add MySQL Access Logs”

  1. nobbler
    nobbler
    October 31, 2011 at 4:39 am |

    you have to add –log-warnings=x where x is larger than 1 to your mysqld execution parameters, see http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_log-warnings

Leave a Reply