Where is MySQL Error Log File

Where is MySQL Error Log File

In Mysql servers, the following methods can be used to find where the error log file is.

Find where the Error Log is with SELECT

We can find where the error log file is with the “SELECT @@log_error;” command.

Find where the Error Log is with mysql daemon parameter

When the mysql service is started, it will start to work with some parameters defined. One of the mysql daemon parameters “-log-error” parameter indicates the location and name of the error file.

dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply