'MySQL: All tables OK but still ERROR 1577 (system tables used by Event Scheduler were found damaged)

From my syslog:

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?

EDIT

I also tried

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

but everything is OK. Still get the error.

mysql


Solution 1:[1]

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

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

Solution 2:[2]

After lot of R&D finally i found solution...........

Basically its happen with mysql 5.7.10 version or earlier versions.

I was getting this error with event table(Mysql event scheduler). solution- click on start menu => search for Mysql installer => click on upgrade=> upgrade all mysql => it's really work.............!

Solution 3:[3]

I use Navicat for structure synchronisation and it's usually hassle-free, but with this problem I wasn't able to correct the base issue on shared hosting. Unticking 'Compare events' under 'Options' on the screen for selection of Source and Target allowed the structure synch to proceed unhindered.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 jagdish desai
Solution 3 Geoff Kendall

Related Questions