这里是普通文章模块栏目内容页
Cannot proceed because system tables used by Event Scheduler were found damaged at server start

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

今天在MYSQL 5.7的数据库上导出数据库时,碰到一个错误信息:Cannot proceed because system tables used by Event Scheduler were found damaged at server start;最近对数据库进行了升级,可能是因为数据库版本不一致造成的,网上找的解决方法,记录一下。


找到mysql/bin目录 ,依次执行如下命令(xxxxxxxxxx为数据库root用户的密码):

mysqlcheck -uroot -pxxxxxxxxxx --all-databases --check-upgrade --auto-repair

mysql_upgrade -uroot -pxxxxxxxxxx --force

如果还是报错,重启mysql服务。



栏目索引
相关内容