连接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.

m ysql> 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>