Mysql ERROR 1577 ERROR solution, mysql1577

Mysql ERROR 1577 ERROR solution, mysql1577

Today, I upgraded Mysql to 5.1.31 and used Navicat to open the database and add data. The error 1577 is displayed. The message is as follows:
Copy codeThe Code is as follows: ERROR 1577 (HY000): Cannot proceed because system tables used by Event sched1_were found damaged at server start.

View the Manual (5.4. mysql_fix_privilege_tables: Upgrade the MySQL system table). Some MySQL releases have changed the structure of the system table in the mysql database and added new permissions or features. When you update to the new MySQL version, you should update the system tables at the same time to ensure that their structure is up-to-date. First back up the mysql database, and then follow the procedure below
Solution:

In Windows, MySQL distribution includes the mysql_fix_privilege_tables.sqlSQL script, which can be run on the mysql client. For example, if MySQL is installed in C: Program FilesMySQLMySQL Server 5.1, the command should be:
Copy codeThe Code is as follows:
C:> C: Program FilesMySQLMySQL Server 5.1 binmysql-u root-p mysqlmysql> source c:/Program Files/MySQL Server 5.1/share/mysql_fix_privilege_tables. SQL

If it is installed in another directory, change the path name accordingly.

The mysql command prompts you to enter the root password. Follow the prompts to enter the password. No error information is required during the operation. After exiting, restart the Mysql server.

The linux solution has not been tried. The excerpt is as follows:

In Unix or Unix systems, run the mysql_fix_privilege_tables script to update the system table:
Copy codeThe Code is as follows:
Shell> mysql_fix_privilege_tables

You must execute this script when the server is running. It tries to connect to the server running with root on the local machine. If the root account requires a password, use the following method in the command line:
Copy codeThe Code is as follows:
Shell> mysql_fix_privilege_tables -- password = root_password

An error occurred while installing the connection error in MySQL.

Solution:

Mysqladmin-h hostname flush-privileges

Use mysql; update user set password = password ('yourpass') where user = 'root'

If the database cannot be connected, run the following command to log on as the root user:
Set password for sns @ 'localhost' = OLD_PASSWORD ('sns ');
Then refresh mysql Permissions
Flush privileges;

Data Import method mysql-u name-p -- default-character-set = utf8 databasename <path \ *. SQL

Create database name character set utf8;

If the Error #1251-Client does not support authentication protocol requested by server; appears:

Solution: log on to the MYSQL server as the root user and run

Mysql> set password for user1 @ "localhost" = old_password ('yourpassword ');

The reason is that the new password verification mechanism is used in the mysql server version you are using. This requires the client version to be later than 4.0. The original password function is changed to old_password ();, in this way, it is difficult to use the password () generated by the client in the old version, while the MYSQL client in PHP is 3.23 (except for mysqli extension ), this is the problem.

Mysql Database error 1146

Have you upgraded mysql or deleted this table? I suspect the table structure is damaged.
Solution:
1) Restart mysql
2) If the problem persists, try the repaire table wp_xxxx table name,
3) if the problem persists, log out of the command line client and go to the bin directory of the mysql installation directory.
Use mysqlcheck-r database name table name-uuser-ppass to fix the issue.