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