Question

how to find log errors in database servers

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

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

@kesamsettyankaiah

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.

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