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