Mysql Event Not Working

檢查排程是否有開啟

SELECT @@event_scheduler;

SELECT @@global.event_scheduler;

設定開啟

SET GLOBAL event_scheduler = ON;

How to force an event to execute in MySQL

Move all the code within the event into a stored procedure
Make the event only call the stored procedure
Test the stored procedure with the CALL syntax.