MySQL 5.1.6 and later provides several SQL statements for working with scheduled events:
When a scheduled event is no longer wanted or needed, it can
be deleted from the server by its definer using the
DROP EVENT statement. See
Section 13.1.22, “
DROP EVENT Syntax”. Whether an event persists past
the end of its schedule also depends on its
COMPLETION clause, if it has one. See
Section 13.1.11, “
CREATE EVENT Syntax”.
An event can be dropped by any user having the
EVENT privilege for the
database on which the event is defined. Prior to MySQL 5.1.12,
a user other than the definer required privileges on the
mysql.event table. See
Section 19.4.6, “The Event Scheduler and MySQL Privileges”.