HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How to drop all scheduler events in MySQL 5.6?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
schedulereventsalldropmysqlhow

Problem

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?

Solution

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;

Code Snippets

set GLOBAL event_scheduler=0;
DROP EVENT [IF EXISTS] event_name;

Context

StackExchange Database Administrators Q#45636, answer score: 2

Revisions (0)

No revisions yet.