access denied for user 'root'@'localhost'(using password: YES)问题解决办法.

access denied for user 'root'@'localhost'(using password: YES)问题解决办法.

文章分类:数据库

按以下步骤操作，即可解决。 
1、C:/Program Files/MySQL/MySQL Server 6.0/bin>mysqld  --defaults-file="C:/Program Files/MySQL/MySQL Server 6.0/my.ini" --console --skip-grant-tables 

2、090515 22:06:09 [Note] mysqld: ready for connections. 
Version: '5.1.33-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)看到这个结果就说明MySQL已经起来了。 
再开一个DOS窗口，同样切到mysql bin目录下， 
C:/Program Files/MySQL/MySQL Server 6.0/bin>mysql -uroot mysql 

3、mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’; 
mysql> FLUSH PRIVILEGES; 
mysql> quit