how to find log errors in database servers

@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