Event not working properly in mysql?

Question

I created an event to execute the first day of each month.

The event is as follows:

DELIMITER $$
CREATE EVENT event2
ON SCHEDULE EVERY '1' MONTH
STARTS '2011-05-01 00:00:00'
DO
BEGIN
 call UpdateIt();
END$$

DELIMITER ;

/* Here Stored procedure "UpdateIt()" will update a row.*/

There is no problem with the stored procedure, its performance.

And I set @@ global.event_scheduler to 1.

Even if it doesn’t work. Can anyone solve this problem please.

Answer 1

1- Create an event as indicated in the question.

2- Change the system date to '2011-04-30 23:58:00'

3- Restart MySQL

MySQL , .
, , , , MySQL .