Breaking News: Grepper is joining You.com. Read the official announcement!

check mysql error log

marktecher.com answered on November 16, 2022 Popularity 9/10 Helpfulness 5/10

answer check mysql error log

related mysql log_error

check mysql error log

Comment

#To have Mysql logs, you have to activate the query logging in mysql.
#1. Edit the <path to your mysql server>/my.cnf file:
#To enable error log add following

[mysqld_safe]
log_error=/var/log/mysql/mysql_error.log

[mysqld]
log_error=/var/log/mysql/mysql_error.log

#To enable general query log add following

general_log_file        = /var/log/mysql/mysql.log
general_log             = 1

#To enable Slow Query Log add following

log_slow_queries       = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes

#2. Restart the computer or the mysqld service
service mysqld restart

#3. Read the log or  
cat /var/log/mysql/mysql.log

#or read real-time

tail -f /var/log/mysql/mysql.log

Popularity 9/10 Helpfulness 5/10 Language shell

Source: stackoverflow.com

Tags: error-log mysql shell

Link to this answer
Share Copy Link

Contributed on Nov 16 2022

marktecher.com

0 Answers Avg Quality 2/10

Closely Related Answers

mysql log_error

Comment

Mysql logs

Popularity 7/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: mysql sql

Link to this answer
Share Copy Link

Contributed on Oct 02 2023

Muhammed Ajmal

0 Answers Avg Quality 2/10

check mysql error log

Contents

More Related Answers

check mysql error log

Closely Related Answers

mysql log_error

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.