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

最新推荐文章于 2024-03-25 14:50:11 发布

weixin_30337157

最新推荐文章于 2024-03-25 14:50:11 发布

阅读量306

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 shell

原文链接：http://www.cnblogs.com/enki-fang/p/10062494.html

本文介绍了解决SQLYog访问MySQL 5.7时出现系统表损坏错误的方法。首先需要退出MySQL并进入shell环境，然后使用mysql_upgrade命令进行表结构升级，并最后重启mysqld服务器。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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服务器）

转载于:https://www.cnblogs.com/enki-fang/p/10062494.html

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

weixin_30337157

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

解决the code execution cannot proceed because mfc140.dll was not found. The application was unable to

落日之城

02-24

1367

(可以看看软件安装目录那几个文件夹是系统软件)里和。仔细检查以下dll文件的版本和你的软件版本.去下载mfc140.dll, 然后放到。"C://windows32/"里.

若依微服务项目报错解决：com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

猿小白的博客

04-24

2654

在每次重启数据库的时候，登录系统会报错。第一次会出现用户名不存在等情况，后台会报错，前端依旧可以进入，或者等待时间5分钟，期间不做任何操作，重新登录，这个问题就会复现，复现这个问题最快的方法就是重启数据库。

参与评论您还未登录，请先登录后发表或查看评论

[bug] Cannot proceed because system tables used by Event Scheduler were found damaged at server sta...

weixin_30457465的博客

04-26

216

本地：mac 10.12.3 mysql 5.6 远程：linux 7.3 mysql 5.7.18. （远程数据库yum安装，又5.6升级到5.7）步骤：从本地数据库导出数据到远程数据库 现象：表，存储过程都可以同步过去，当执行：show events ; 出现 Cannot proceed because system tables used by Event Sch...

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

飘然渡沧海的博客

09-06

2401

mysql_upgrade 检查所有数据库中与mysql服务器当前版本不兼容的所有表，mysql_upgrade也会升级系统表，以便你能使用新添加的权限或功能。如果mysql_upgrade发现一张表可能不兼容，将该表进行检查，如果发现问题，则试图对其进行修复。如果不能修复，则需要人工进行表和索引的重建或修复。每次升级mysql，都需要运行mysql_upgrade。今天因测试库出现了一点问题，怀疑某些人误操作对数据库进行了升级。mysqlcheck是用来检查，分析，优化，修复表的。重启mysql服务。

Mysql出现”Cannot proceed because system tables used by Event Scheduler were found

wing123123的博客

08-05

4209

在用Navicat 导出mysql数据库的时候出现 “Cannot proceed because system tables used by Event Scheduler were found damaged at server start” . 怎么办呢? 按下面的操作吧: 连接到Mysql. 打开 mysql库.执行查询. 查询内容: DROP TABLE IF EXIST...

mysql 出现 Cannot proceed because system tables used by Event Scheduler were found damaged at server

leeafu的专栏

05-31

7137

转自：http://www.52study.org/bencandy.php?fid-43-id-642-page-1.htm mysql用客户端导出sql文件时出错提示 “ Cannot proceed because system tables used by Event Scheduler were found damaged at server start” （在

Navicat导出SQL数据报错1577，Cannot proceed because system tables used by Event Scheduler where found damage

最新发布

DBA之路的博客

03-25

834

重启 MySQL服务。

Mysql出现”Cannot proceed because system tables used by Event Scheduler were found damaged at server st

西门飘雪的博客

03-16

667

在用Navicat 导出mysql数据库的时候出现 “Cannot proceed because system tables used by Event Scheduler were found damaged at server start” . 怎么办呢?连接到Mysql. 打开 mysql库.执行查询.重启Mysql server。

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

bglmmz的专栏

10-25

765

今天在一个MYSQL 5.7的数据库上创建event时，碰到一个错误信息：Cannot proceed because system tables used by Event Scheduler were found damaged at server start 古狗了解决方法，记录一下：找到mysql/bin目录依次执行如下命令： mysqlcheck -uroot...

Navicat的1577 – Cannot proceed because system tables used by Event Scheduler where found damaged at s

乔布尸

12-19

1745

今天使用Navicat不过当连接上新mysql后，无论打开任何一个数据库，都会提示：1577 – Cannot proceed because system tables used by Event Scheduler where found damaged at server start，按照提示的说法是系统表损坏，但没有理由全部都损坏吧。于是上网查些相关信息，但比较失望，没有实际的解决

mysql 1577_ERROR 1577 (HY000): Cannot proceed because system tables&nbsp

weixin_30431137的博客

01-27

425

mysql> select *frominformation_schema.events;ERROR 1577 (HY000): Cannot proceed because system tables usedby Event Scheduler were found damaged at server startmysql> show variables like 'event_...

黄聪：Navicat for MySQL的1577错误解决

weixin_34107955的博客

10-26

526

今天尝试使用了Windows下的可视化mysql数据库管理工具Navicat，界面清爽，易操作上手，感觉还不错。不过当连接上mysql后，无论打开任何一个数据库，都会提示：1577 – Cannot proceed because system tables used by Event Scheduler where found damaged at server start，按照提示的说...

navicat备份出现Cannot proceed because system tables used by Event Scheduler were found damaged at server

童大大的专栏

04-26

755

Navicat链接linux上的mysql出现 1577 Cannot proceed because system tables used by Event Scheduler where foun

your_Heart_Private的博客

08-24

2979

之前用navicat链接远程linux上的mysql一直都挺好使的，今天导出数据的时候发现，出现了下图错误。百度一下解决方法是: (1)windows上的mysql出现1577，方法一百度一大堆，下载mysql_upgrade.exe和mysqlcheck.exe文件放到mysql的bin目录下，然后执行mysql_upgrade -u root -p后重启mysql就ok啦。 (2)...

Navicat连接mysql备份数据库提示：1577 – Cannot proceed because system tables used by Event Scheduler where foun...

weixin_30770783的博客

01-08

600

解决办法，可以参考试试： http://www.cnblogs.com/huangcong/p/3389010.html http://blog.csdn.net/phpfenghuo/article/details/40537477 转载于:https://www.cnblogs.com/rgqancy/p/8241612.html

mysql 安装the code execution cannot proceed because vcruntime140.dl! was not

09-20

当在安装 MySQL 遇到 "the code execution cannot proceed because vcruntime140.dll was not found" 错误时，这意味着你的计算机缺少了 vcruntime140.dll 这个动态链接库文件。 vcruntime140.dll 是 Visual C++ ...