CODEWITHSUNDEEP
mysqlevent-log
Alexandru Dicu
Alexandru Dicu

Reputation: 1225

MySQL enable Windows event logging

I have MySQL Server 8.0.21 installed on my Windows 10 machine. I want to enable Windows event logging so that I can see the errors in Windows Event Viewer instead of a txt log file. I am using the documentation from here: https://dev.mysql.com/doc/refman/8.0/en/error-log-configuration.html

INSTALL COMPONENT 'file://component_log_sink_syseventlog';
SET GLOBAL log_error_services = 'log_filter_internal; log_sink_syseventlog';

However, when I try to execute:

mysql> INSTALL COMPONENT 'file://component_log_sink_syseventlog';

It gives me the error:

ERROR 3536 (HY000): Initialization method provided by component 'mysql:log_sink_syseventlog' failed.

Did anyone manage to enable logging to event log in Windows for MySQL ? Thank you.

Upvotes: 0

Views: 1538

Answers (1)

Reese Allison
Reese Allison

Reputation: 43

I was experiencing the same issue. I was able to install other components but component_log_sink_syseventlog kept failing on MySQL 8.0.21. My issue was resolved by updating to 8.0.22 which makes me think it was just broken. I experienced this issue on Windows 10 and Windows Server 2016 and updating fixed it on both platforms.

Upvotes: 1

Related Questions