By default MySql event scheduler settings are turned OFF. Execute the below commands to turn ON event scheduling in MySql
show variables where variable_name='event_scheduler';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
SET GLOBAL event_scheduler = ON;
show variables where variable_name='event_scheduler';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
No comments:
Post a Comment