Mysql error 1577 Troubleshooting method _mysql

Today, the MySQL upgrade to 5.1.31, with Navicat open the database to add data, there are 1577 errors, prompting information:

Copy Code code as follows:

ERROR 1577 (HY000): cannot proceed because system tables used by Event Scheduler were found damaged at server start.

View Manual (5.4. Mysql_fix_privilege_tables: Upgrade the MySQL system table), some MySQL publications have made changes to the structure of the system tables in the MySQL database, adding new permissions or attributes. When you update to the new version of MySQL, you should also update the system tables to ensure that their structure is up to date. First back up the MySQL database, and then follow the following procedure
The solution is:

In Windows systems, MySQL distribution includes mysql_fix_privilege_tables.sqlsql scripts that you can run with MySQL clients. For example, if MySQL is installed to C:Program filesmysqlmysql Server 5.1, the command should be:

Copy Code code as follows:

C:>c:program filesmysqlmysql server 5.1binmysql-u root-p mysqlmysql>source c:/program Server 5. 1/share/mysql_fix_privilege_tables.sql

If you install to a different directory, change the path name accordingly.

The MySQL command prompts for the root password and enters the password as prompted. Run time without the error message, complete the exit, restart the MySQL server can

Linux solutions, not tried, excerpts are as follows:

In Unix or Unix class systems, run the Mysql_fix_privilege_tables script to update the system tables:

Copy Code code as follows:

Shell>mysql_fix_privilege_tables

You must execute the script while the server is running. It attempts to connect to a server running on this computer with root. If the root account requires a password, give the password at the command line as follows:

Copy Code code as follows:

Shell> Mysql_fix_privilege_tables--password=root_password