lmysql5.7开启事件 event_scheduler

Question

错误码: 1290
The MySQL server is running with the --event-scheduler=DISABLED or --skip-grant-tables option so it cannot execute this statement

Answer 1

update mysql.user set authentication_string=password('your_pwd') where user='root';
flush privileges;