I want to set the event_scheduler
global to ON
even if MySQL is restarted; how can I achieve this?
SET GLOBAL event_scheduler = ON;
You can set
event_scheduler=ON
in my.ini
or my.cnf
file, then restart your server for the setting to take effect.
Once set event_scheduler
will always remain ON
no matter whether your server restarts.