MySQL:所有表都可以，但仍然会出现错误1577(发现Event Scheduler使用的系统表已损坏) [英] MySQL: All tables OK but still ERROR 1577 (system tables used by Event Scheduler were found damaged)

问题描述

从我的系统日志中:

mysql[1663]: ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by Event Scheduler were found damaged at server start

我尝试使用此命令来查找损坏的表:

I tried this command to find damaged tables:

mysqlcheck -A --auto-repair --password

但是所有表都可以.现在该怎么办?

but all tables are OK. What's to do now?

编辑

我也尝试过

sudo mysql_upgrade -u root -h localhost -p --verbose --force

但是一切都很好.仍然会收到错误.

but everything is OK. Still get the error.

推荐答案

我遇到了同样的问题，尽管我没有发现任何错误或问题，但得到了这些警告.他们似乎无害.

I had the same problem, altough I didn't notice any errors or problems, I got those warnings. They seemed harmless.

对于debian，我使用MariaDB Ver 15.1 Distrib 10.3.22-MariaDB，您的命令完美地解决了该问题:

I use MariaDB Ver 15.1 Distrib 10.3.22-MariaDB, for debian and your command fixed the issue perfectly:

 mysql_upgrade -u root -h localhost -p --verbose --force

这篇关于MySQL:所有表都可以，但仍然会出现错误1577(发现Event Scheduler使用的系统表已损坏)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！