how to find log errors in database servers

July 19, 2017 1.8k views
LAMP Stack Linux Commands Arch Linux

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

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.

Have another answer? Share your knowledge.