MySQL Forums
Forum List  »  Newbie

mysql 8.0 Error log is empty
Posted by: Mark Blake
Date: June 14, 2021 10:15PM

I have a fairly fresh installation of mysql 8.0.25 on Ubuntu 20-04, its the default install on an Amazon lightsail instance.

The error log file is always empty, and wont record any events and its driving me nuts, I need to see login failures, and am testing by fudging a good username or password and getting a connection failure, but nothing ever gets recorded in this log file. I have read the fine manual pages but its way too complicated and verbose for me to get my head around a simple process to save errors to the log file. Nevertheless I am fairly certain my configuration is correct. I have searched a lot and cant find anything to assist.

my log-error configuration is

log_error /var/log/mysql/error.log
log_error_services log_filter_internal; log_sink_internal
log_error_suppression_list
log_error_verbosity 3

/var/log/mysql/error.log file permission is 640 and every day it gets rotated to another empty file and after 2 days its deleted.

any suggestions truly appreciated.

Options: ReplyQuote


Subject
Written By
Posted
mysql 8.0 Error log is empty
June 14, 2021 10:15PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.