[How To] Enable MySQL Event Scheduler status

The event scheduler in MySQL needs to be enabled for some applications to work flawlessly.
In this case, a small change is required in the MySQL configuration file my.cnf.

Steps:

1. Open my.cnf file in your favourite editor

vi /etc/my.cnf

2. Add following line

event_scheduler=on

This will enable MySQL event scheduler on the server.

3. Restart MySQL service

 /etc/init.d/mysql restart

That's all!

About Abhijit Sandhan

Loves Open Source, Blogging, Traveling, Hiking and sharing Knowledge!

Leave a Reply

Your email address will not be published. Required fields are marked *