重置遗忘的mysql密码

第一步：查找mysql进程

第二步：关闭mysql进程

C:\Documents and Settings\Administrator>taskkill /f /im mysqld.exe
成功: 已终止进程 "MYSQLD.EXE"，其 PID 为 720。

第三步：跳过授权表
C:\Documents and Settings\Administrator>mysqld -nt --skip-grant-tables
150327 16:42:19 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.
150327 16:42:19 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
150327 16:42:19 [Warning] option 'new': boolean value 't' wasn't recognized. Set to OFF.

第四步：进入mysql

C:\Documents and Settings\Administrator>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.21-log MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

第五步：重置mysql密码

mysql> use mysql
Database changed
mysql> update user set password=password('root') where user='root';            【注释：修改密码，注意要用password函数修改密码】
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> flush privileges;                                                     【注释：刷新特权】
Query OK, 0 rows affected (0.00 sec)

mysql>

第六步：关闭mysql进程

重复第一步操作。

第七步：验证密码（开启mysql服务登录）
C:\Documents and Settings\Administrator>net start mysql
MySQL 服务正在启动 ..
MySQL 服务已经启动成功。
C:\Documents and Settings\Administrator>mysql -u root -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.21-log MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

参考链接：http://blog.163.com/zcl__ok/blog/static/1690516482011513256839/

                    http://www.jb51.net/article/38473.htm