Speaktech.in

mysql enable the event scheduler

SHOW VARIABLESWHERE VARIABLE_NAME ='event_scheduler'
we can enable the event scheduler by following query:
SET GLOBAL event_scheduler =ON;

Similarly, to turn off the scheduler:

SET GLOBAL event_scheduler =OFF;