Tips
don't forget to enable events,
SET GLOBAL event_scheduler = ON;
change my.cnf file to make it persistent,
be sure it should under [mysqld]
event_scheduler=ON
is event_scheduler enabled?
SHOW VARIABLES WHERE VARIABLE_NAME = 'event_scheduler'
you can list events on database,
show events where name='myEventName';
or
select * from mysql.event where name='myEventName';
useful links,
mysql reference: create event
mysql reference: alter event