Debian / Ubuntu MySQL Error Log File Location

last updated in Categories ,

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.err

Posted by: Vivek Gite

The author is the creator of nixCraft and a seasoned sysadmin, DevOps engineer, and a trainer for the Linux operating system/Unix shell scripting. Get the latest tutorials on SysAdmin, Linux/Unix and open source topics via RSS/XML feed or weekly email newsletter.

Share this on (or read 2 comments/add one below):

2 comment

  1. 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.

    Have a question? Post it on our forum!