MySQL / How to enable Event Scheduler

In order to enable Event Scheduler functionality in MySQL, you need to place 

event_scheduler=on

somewhere under the [mysqld] section in the default mysql config file (my.cnf).

In Debian/Ubuntu this file usually lives at /etc/mysql folder:

$ ls /etc/mysql/
conf.d  debian.cnf  debian-start  my.cnf

No comments:

Post a Comment