Mysql – How to drop all scheduler events in MySQL 5.6

jobsmysql-5.6

In MySQL 5.6 is there a way to drop all scheduler events with an administrative command or do I have to go through them one by one with DROP EVENT [IF EXISTS] event_name?

Best Answer

you can disable them via the following command:

set GLOBAL event_scheduler=0;

or dropping them one by one using the command:

DROP EVENT [IF EXISTS] event_name;
Related Question