MySQL: Log Files in Linux / UNIX / BSD

Can you tell me where are MySQL error and other log files are located under Linux / UNIX / BSD operating systems?

MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is also the default location for other information such as log files and status files.

ADVERTISEMENTS

MySQL Log File Location Under Different Linux Distributions

  1. Redhat / RHEL / CentOS / Fedora Linux – /var/log/mysqld.log
  2. Debian / Ubuntu Linux – /var/log/mysql.log
  3. FreeBSD/var/db/mysql/`hostname`.err (if your hostname is db2.nixcraft.com, than log file name should be /var/db/mysql/db2.nixcraft.com.err

How Do I View MySQL Log Files?

Use the following commands as root user:

tail -f /var/log/mysql.log
grep 'something' /var/log/mysql.log
less /var/log/mysql.log
🐧 Get the latest tutorials on SysAdmin, Linux/Unix, Open Source/DevOps topics:
CategoryList of Unix and Linux commands
File Managementcat
FirewallCentOS 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
0 comments… add one

Leave a Reply

Your email address will not be published.

Use HTML <pre>...</pre>, <code>...</code> and <kbd>...</kbd> for code samples.