Search code examples
mysqldatabaseeventsschedulermysql-event

How to persist `event_scheduler` to be `ON` even if MySQL is restarted?


I want to persist event_scheduler to be ON even if MySQL is restarted; how can I achieve this?

SET GLOBAL event_scheduler = ON;

Solution

  • One Way - You can set your system variables and use those variables if there is any possibility to restart your mysql.

    Here is link Using system variables in mysql