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:

ADVERTISEMENTS

  • /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 SysAdmin, Linux/Unix, Open Source/DevOps topics:
CategoryList of Unix and Linux commands
File Managementcat
FirewallAlpine Awall CentOS 8 OpenSUSE RHEL 8 Ubuntu 16.04 Ubuntu 18.04 Ubuntu 20.04
Network Utilitiesdig 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 jobs killall kill pidof pstree pwdx time
Searchinggrep whereis which
User Informationgroups id lastcomm last lid/libuser-lid logname members users whoami who w
WireGuard VPNCentOS 8 Debian 10 Firewall Ubuntu 20.04

ADVERTISEMENTS
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>, <code>...</code> and <kbd>...</kbd> for code samples.