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

🐧 Get the latest tutorials on Linux, Open Source & DevOps via RSS feed or Weekly email newsletter.

🐧 2 comments so far... add one


CategoryList of Unix and Linux commands
Disk space analyzersdf duf ncdu pydf
File Managementcat cp mkdir tree
FirewallAlpine Awall CentOS 8 OpenSUSE RHEL 8 Ubuntu 16.04 Ubuntu 18.04 Ubuntu 20.04
Modern utilitiesbat exa
Network UtilitiesNetHogs dig host ip nmap
OpenVPNCentOS 7 CentOS 8 Debian 10 Debian 8/9 Ubuntu 18.04 Ubuntu 20.04
Package Managerapk apt
Processes Managementbg chroot cron disown fg glances gtop jobs killall kill pidof pstree pwdx time vtop
Searchingag grep whereis which
User Informationgroups id lastcomm last lid/libuser-lid logname members users whoami who w
WireGuard VPNAlpine CentOS 8 Debian 10 Firewall Ubuntu 20.04
2 comments… add one
  • Estêvão Samuel Procópio Jun 25, 2011 @ 16:30

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

  • Michael McDonald Apr 30, 2013 @ 10:36

    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 Reply

Your email address will not be published.

Use HTML <pre>...</pre> for code samples. Still have questions? Post it on our forum