mysql 8.0 Error log is empty
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.
Subject
Written By
Posted
mysql 8.0 Error log is empty
June 14, 2021 10:15PM
Sorry, you can't reply to this topic. It has been closed.
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.