Problem:
Today, navicat is used. However, when a new MySQL instance is connected, no matter whether a database is opened, the system prompts 1577-cannot proceed because system tables used by event scheduler where found damaged at Server start, according to the prompts, the system table is damaged, but there is no reason for all damages.
Solution:
So I checked some information online, but I was disappointed that there was no practical solution. After some tossing, I found some information in the MySQL Chinese manual. It turned out that the structure of the system table was greatly adjusted since MySQL, you must upgrade the system table structure for normal use.
Then, I found a message on navicat's official website: Please try to update your system table and to see if it solves your problem. mysql_upgrade is stored in the "bin" folder under the MySQL Server installation path.
It means to run the mysql_upgrade program in the bin directory of MySQL to upgrade and update the system table to solve the problem. I am using apmserv5.2.6 to build a platform integrated with the PHP environment. I chose mysql5.1. However, the mysql_upgrade file is not found in the bin directory of mysql5.1. It seems that the author of apmserv has simplified the file accordingly.
Finally, I had to go to the MySQL official site to download the corresponding zip package, extract the corresponding file, and run it. The problem was solved.
Method:
1. Copy the mysql_upgrade.exeand mysqlcheck.exe files to the apmserv5.2.6 \ mysql5.1 \ bin directory.
2. Start-> Run-> Enter cmd and press Enter. At the operation prompt, enter E: \ apmserv5.2.6 \ mysql5.1 \ bin \ mysql_upgrade-u root-P (database username and password) press enter to close the DOS window after running. (Change E: \ apmserv5.2.6 to the directory you actually installed)
3. Stop apmserv and restart apmserv once (preferably restart your computer). The problem can be solved.
navicat 1577-cannot proceed because system tables used by event scheduler where found damaged at S
