how to permanently activate/set the global event_scheduler to 1 in mysql

If you are using WAMP :

Open its control panel by clicking on the WAMP icon -> mysql-> my.ini

Its location may be at:

C:\wamp\bin\mysql\mysql{your.ver.sion}

Add EVENT_SCHEDULER=ON under [mysqld] - not [mysql] notice the "d" for daemon. Another tip to ascertain where you're adding is where your (default) server port is specified.

[mysqld]
port=3306
event_scheduler=on

Yes, write event_scheduler=on somewhere under the [mysqld] section in the default mysql config file, usually /etc/my.cnf

Tags:

Mysql

Events