连接mysql提示Access denied for user 'root'@'localhost'

MySQL版本：MySQL 5.5.8

连接MySQl：mysql -uroot -proot

提示信息： Access denied for user 'root'@'localhost'

1. 停止 MySQL 服务

2. D:/Program/MySQL/MySQL Server 5.5/bin>mysqld --defaults-file="D:/Program/MySQL/MySQL Server 5.5/my.ini" --console --skip-grant-tables

101219 21:39:10 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Compressed tables use zlib 1.2.3 101219 21:39:10 InnoDB: Initializing buffer pool, size = 47.0M 101219 21:39:10 InnoDB: Completed initialization of buffer pool 101219 21:39:10 InnoDB: highest supported file format is Barracuda. 101219 21:39:10 InnoDB: 1.1.4 started; log sequence number 1595675 101219 21:39:10 [Note] mysqld: ready for connections. Version: '5.5.8' socket: '' port: 3306 MySQL Community Server (GPL)

--看到这个结果就说明MySQL已经起来了。

3. 启动 MySQL 服务

4. 再开一个DOS窗口，同样切到mysql bin目录下，

D:/Program/MySQL/MySQL Server 5.5/bin>mysql -uroot mysql

Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 2 Server version: 5.5.8-community-log MySQL Community Server (GPL) Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';

mysql> FLUSH PRIVILEGES;

mysql> quit

5. D:/Program/MySQL/MySQL Server 5.5/bin>mysqladmin shutdown

6. 正常重启 MySQL 服务就行了。

7. D:/Program/MySQL/MySQL Server 5.5/bin>mysql -uroot -p

Enter password: ****

Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 2 Server version: 5.5.8 MySQL Community Server (GPL) Copyright (c) 2000, 2010, 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>