Mysql event does not run at specified time

Question

I created an event in mysql so that every day on time 00:05:00 Starting on 07/18/2021, it performs an update on a table, only it is not running at the given time, what might be happening? Follow the script I used to create the Event

OBS.: He even made the first execution (the day I created the event), but did not repeat in the other days, even configured as a recurring event.

CREATE DEFINER=`root`@`localhost` EVENT `EventStatusUpdate`
    ON SCHEDULE
        EVERY 24 HOUR STARTS '2021-07-18 00:05:00'
    ON COMPLETION PRESERVE
    ENABLE
    COMMENT ''
    DO BEGIN

UPDATE usuario
SET   status = 1
WHERE status = 0;

END

Answer 1

"starting on 18/07/2021" this must be the problem, if you try to create an event with a retroactive date it will not work, the STARTS should always be a later date.

For example, at the time of this answer is "20/07/20121 15:00", so you can only schedule (in the case of your example) to start from "21/07/20121 00:05:00".

Create the event with STARTS for the next day and it will work.
Can also change the EVERY 24 HOUR STARTS for EVERY 1 DAY STARTS

Finally, don’t forget to confirm that the event was created correctly and also if Scheduler is active, otherwise it will not start the event next time. To confirm use the command SHOW PROCESSLIST, see if the list shows your event and the "event_scheduler", which is the agent that starts the scheduled events.