≡ Menu

Debian / Ubuntu MySQL Error Log File Location

Can you tell me the location of for the MySQL error log file under Debian or Ubuntu Linux? How do I view error log file?

The data directory is also the default location for other information such as log files and status files. However, under Debian and Ubuntu Linux the MySQL error log file location is as follows:

  • /var/log/mysql.err - MySQL Error log file
  • /var/log/mysql.log - MySQL log file

You can use the commands as follows:

grep 'something' /var/log/mysql.err
tail -f  /var/log/mysql.err
less /var/log/mysql.e
Tweet itFacebook itGoogle+ itPDF itFound an error/typo on this page?

{ 2 comments… add one }

  • Estêvão Samuel Procópio June 25, 2011, 4:30 pm

    Try to take a look in /var/log/syslog for mysql errors…

  • Michael McDonald April 30, 2013, 10:36 am

    99.9% of users will find their mysql logs in /var/syslog

    Especially if they installed apache2 and didn’t manually change the logging paths in the .ini file.

Leave a Comment