解决方法

[root@server ~]# /etc/init.d/mysqld stop
 Stopping MySQL:                                          [ OK ]

 [root@server ~]# mysqld_safe --skip-grant-tables &
 [1] 24359
 [root@server ~]# Starting mysqld daemon with databases from  /var/lib/mysql

 [root@server ~]# mysql -u root
 Welcome to the MySQL monitor. Commands end with ; or g.
 Your MySQL connection id is 1
 Server version: 5.0.77 Source distribution
 Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

 mysql> show databases;
 +--------------------+
 | Database           |
 +--------------------+
 | information_schema |
 | mysql              |
 | openfire           |
 +--------------------+
 3 rows in set (0.13 sec)

 mysql> use mysql;
 Reading table information for completion of table and column names 
 You can turn off this feature to get a quicker startup with -A
 Database changed

 mysql> show tables;
 +---------------------------+
 | Tables_in_mysql           |
 +---------------------------+
 | columns_priv              |
 | db                        |
 | func                      |
 | help_category             |
 | help_keyword              |
 | help_relation             |
 | help_topic                |
 | host                      |
 | proc                      |
 | procs_priv                |
 | tables_priv               |
 | time_zone                 |
 | time_zone_leap_second     |
 | time_zone_name            |
 | time_zone_transition      |
 | time_zone_transition_type |
 | user                      |
 +---------------------------+
 17 rows in set (0.00 sec)

 mysql> update user set password=PASSWORD("new_paswd") where User='root';
 Query OK, 3 rows affected (0.05 sec)
 Rows matched: 3 Changed: 3 Warnings: 0

 mysql> flush privileges;
 Query OK, 0 rows affected (0.04 sec)

 mysql> quit
 Bye

 [root@server ~]# /etc/init.d/mysqld restart
 STOPPING server from pid file /var/run/mysqld/mysqld.pid
 102675 04:17:15 mysqld ended
 Stopping MySQL:                                          [ OK ]
 Starting MySQL:                                          [ OK ]
 [1]+ Done mysqld_safe --skip-grant-tables

 root@server ~]# mysql -u root -p 
 Enter password:
 Welcome to the MySQL monitor. Commands end with ; or g.

 mysql> quit
 Bye
 

这个错误通常是在尝试访问您的 MYSQL 数据库时弹出