Mysql Event scheduler on Linux

Question

I have tried in my /etc/my.cnf file:

event-scheduler = ON

using MYSQL 5.5. I have turned service off/on, but no global variable EVENT_SCHEDULER = ON

Christian Giupponi · Accepted Answer · 2018-08-30 12:05:07Z

3

In the [mysqld] section of the my.cnf, add this:

event_scheduler=ON

That should enable it for future start ups.

For your current MySQL session you can enable it by doing this:

SET GLOBAL event_scheduler = 1;

7,62811 gold badges76 silver badges120 bronze badges

answered Apr 25, 2012 at 16:49

wrangler

2,0352 gold badges21 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1