ERROR 1290 (HY000)

mysql忘记了root密码，使用skip-grant-tables方式启动后，用set password的方式修改root密码时遇到错误

ERROR 1290 (HY000)

1.以skip-grant-tables方式启动mysql

C:\Users\>mysqld --skip-grant-tables
130411 10:09:30 [Warning] '--default-character-set' is deprecated and will be removed in a future re
lease. Please use '--character-set-server' instead.
130411 10:09:30 [Warning] Changed limits: max_open_files: 2048  max_connections: 700  table_cache: 6
69

 

 2. 用root用户登录，不用输入密码

C:\Users\>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.54-community-log MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

3.用set password 方式修改root密码遇到错误ERROR 1290 (HY000)

mysql> set password for root@'localhost'=PASSWORD('12345');
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot exe
cute this statement

4. 用update方式修改root密码正常
mysql> update mysql.user set password=password('12345') where user='root' and host='localhost';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

5.刷新权限

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

看来以skip-grant-tables方式启动mysql后，不能用set password的方式修改root密码