mysql：Cannot proceed because system tables used by Event Scheduler were found damaged at server start

mysql 5.7.18

sqlyog访问数据库，查看表数据时，出现

Cannot proceed because system tables used by Event Scheduler were found damaged at server start

原因：5.1升级到5.7的时候，数据库配置表的结构发生了一些变化（事件相关）

 

解决方法：

 

1.退出mysql，进入shell环境

 

2.mysql_upgrade -uaccount -ppassword. (升级表结构)

 

3.systemctl restart mysqld （重启mysqld服务器）