how to find log errors in database servers

Posted July 19, 2017 3.9k views
Arch LinuxLAMP StackLinux Commands

i am not unable to find error logs in /var/log/massages

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
2 answers

Hi @kesamsettyankaiah

Are you running MySQL, then the error log is usually located in /var/log/mysql/error.log but sometimes it’s called /var/log/mysql.err.
If your configuration is setup to use syslog and you haven’t created a specific file output, then you’ll see the logging (together with a lot of other stuff) in /var/log/syslog


Login using your mysql client mysql -uroot -p then use this query to find your mysql error log

show variables like "log_error"; to find your error log

Hope this helps.