How do I turn on the event scheduler in mysqld permanently? I'm using phpMyAdmin and I have scheduled an event to copy records from one table to another everyday at a specific time, but the records are not being copied everyday. I've tried setting the event scheduler on.
SET GLOBAL event_scheduler="ON";
When I restart my pc, the event scheduler is turned off. How do I make it be always on, and not turned off when mysqld is restarted?