Home  >  Article  >  Database  >  MySQL错误:access denied for user 'root'@'localhost' usi_MySQL

MySQL错误:access denied for user 'root'@'localhost' usi_MySQL

WBOY
WBOYOriginal
2016-06-01 13:42:391108browse

bitsCN.com
本来mysql运行得好好的,修改了一次root密码,貌似没成功,当时也没在意,mysql也没出问题。到了第二天,启动时报了这个错误“access denied for user 'root'@'localhost' using password yes”。网上解决的方法很多,试了几个都不行,下面就贴出自己实践成功后的方法,

以下内容根据论坛“http://topic.csdn.net/u/20090515/21/2b3c9a12-d8a5-4bb1-9895-6069cef5aef8.html”整理,使得解决方法有个更清晰的步骤。 1.首先进入windows命令行模式,本人的mysql安装在C盘,切换到mysql bin目录下。命令格式如下。C代码      cd C:/program files/mysql/mysql server 5.1/bin  2.停止mysql的服务,敲入下面命令:C代码  C:/Program Files/MySQL/MySQL Server 5.1/bin>mysqld --defaults-file="C:/Program  Files/MySQL/MySQL Server 5.1/my.ini" --console --skip-grant-tables     看到如下结果就说明启动成功了C代码  Version: '5.1.33-community-log' socket: '' port: 3306 MySQL Community Server  (GPL)  3.再打开一个dos窗口,同样切换到bin目录下C代码  C:/Program Files/MySQL/MySQL Server 5.1/bin>mysql -uroot mysql    显示结果如下:C代码   Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 2  Server version: 5.1.33-community-log MySQL Community Server (GPL)    Type 'help;' or '/h' for help. Type '/c' to clear the buffer.  
4.继续下面这个步骤,输入: C代码      # /etc/init.d/mysql stop    # mysqld_safe --user=mysql --skip-grant-tables --skip-networking &    # mysql -u root mysql    mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;    mysql> FLUSH PRIVILEGES;    mysql> quit    # /etc/init.d/mysql restart    # mysql -uroot -p    Enter password:    mysql>       到此为止,成功更新了密码。   作者 dsea bitsCN.com

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn