Menu
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; 
605
Creating new MySQL events First, specify the name of the event that you want to create the CREATE EVENT keywords. The event names must be unique within the same database. Second, specify a schedule after the ON SCHEDULE keywords. Third, place SQL statements after the DO keyword.
SET GLOBAL event_scheduler = OFF; SET @@global. event_scheduler = OFF; SET GLOBAL event_scheduler = 0; SET @@global. event_scheduler = 0; but it stops all 5 event Scheduler.
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.
196
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
