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.

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
 

• Tweet
• 
• 

You should follow me on twitter here or grab rss feed to keep track of new changes.

Featured Articles:

• 30 Handy Bash Shell Aliases For Linux / Unix / Mac OS X
• Top 30 Nmap Command Examples For Sys/Network Admins
• 25 PHP Security Best Practices For Sys Admins
• 20 Linux System Monitoring Tools Every SysAdmin Should Know
• 20 Linux Server Hardening Security Tips
• Linux: 20 Iptables Examples For New SysAdmins
• Top 20 OpenSSH Server Best Security Practices
• Top 20 Nginx WebServer Best Security Practices
• 20 Examples: Make Sure Unix / Linux Configuration Files Are Free From Syntax Errors
• 15 Greatest Open Source Terminal Applications Of 2012
• My 10 UNIX Command Line Mistakes
• Top 10 Open Source Web-Based Project Management Software
• Top 5 Email Client For Linux, Mac OS X, and Windows Users
• The Novice Guide To Buying A Linux Laptop