How to Enable MySQL Event Scheduler status

We needs to enable the event scheduler in MySQL for some applications to work properly.
In this case, a small change is required in the MySQL configuration file my.cnf.

Open my.cnf file in your favorite editor

nano /etc/my.cnf

Add following line

event_scheduler=on

This will enable MySQL event scheduler on the server.

Restart MySQL service

/etc/init.d/mysql restart

That’s all.