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:
Adblock detected 😱
My website is made possible by displaying online advertisements to my visitors. I get it! Ads are annoying but they help keep this website running. It is hard to keep the site running and producing new content when so many people block ads. Please consider donating money to the nixCraft via
PayPal/
Bitcoin, or become a
supporter using Patreon.
- /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 |
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.
Try to take a look in /var/log/syslog for mysql errors…
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.