[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 Facebook2
Share on Google+1Tweet about this on TwitterShare on StumbleUpon0Share on LinkedIn2Share on Tumblr0Digg thisPin on Pinterest0Share on Reddit0Email this to someonePrint this page
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!

Review Overview

User Rating: Be the first one !

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 *

CAPTCHA