[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!

Share on Facebook2Share on Google+0Tweet about this on TwitterShare on StumbleUpon0Share on LinkedIn2Share on Tumblr0Pin on Pinterest0Email this to someonePrint this page

About Abhijit Sandhan

Abhijit Sandhan

Loves Linux, Blogging, Traveling, Hiking and sharing Knowledge!

Leave a Reply

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