ERROR 1045 (28000)Access denied for user root localhost using passwordNO
来源:互联网 发布:龙渊网络 编辑:程序博客网 时间:2024/06/13 21:36
参考网址:
http://stackoverflow.com/questions/19989418/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-n
具体办法:
Follow the steps given below:
- Stop your MySQL server completely. This can be done by accessing the Services window inside Windows XP and Windows Server 2003, where you can stop the MySQL service.
- Open your MS-DOS command prompt using "cmd" inside the Run window. Inside it navigate to your MySQL bin folder, such as C:\MySQL\bin using the cd command.
- Execute the following command in the command prompt: mysqld.exe -u root --skip-grant-tables
- Leave the current MS-DOS command prompt as it is, and open a new MS-DOS command prompt window.
- Navigate to your MySQL bin folder, such as C:\MySQL\bin using the cd command.
- Enter mysql and press enter.
- You should now have the MySQL command prompt working. Type use mysql; so that we switch to the "mysql" database.
- Execute the following command to update the password:
UPDATE user SET Password = PASSWORD('NEW_PASSWORD') WHERE User = 'root';
However, you can now run any SQL command that you wish.
After you are finished close the first command prompt and type exit; in the second command prompt windows to disconnect successfully. You can now start the MySQL service.
不过按照上面这样解决在我的WIN7电脑上执行UPDATE user SET Password = PASSWORD('NEW_PASSWORD') WHERE User = 'root'; 命令时出现了另一个问题:
ERROR 1054 (42S22): Unknown column 'password' in 'field list'
参考网址:
http://www.cnblogs.com/linchw3/p/5255800.html
晚上被这个问题折腾了好久,最后发现window下这个版本的mysql密码列是authentication_string,所以正确的写法是:
mysql>update mysql.user set authentication_string=password('123456') where user='root' and Host ='localhost';
问题解决
0 0
- ERROR 1045 (28000)Access denied for user root localhost using passwordNO
- mysql ERROR 1045 access denied for user 'root'@'localhost' using
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user root@localhost (using password: no)
- ubuntu MySQL访问时出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
- ERROR 1045 (28000): Access denied for user'root'@'localhost'(using password:YES)
- mysql-->ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- ERROR 1045 (28000): Access denied for user’root’@'localhost’(using password:YES)
- mysql 报错处理ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YSE)
- ERROR 1045 (28000): Access denied for user root@localhost (using password: NO) 的解决办法 ---linux
- ERROR 1045 (28000): Access denied for user root@localhost (using password: YES)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- ubuntu mysql问题 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YSE)解决
- ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- AndroidStudio2.0开发环境搭建
- OpenCV Canny 源码解析
- hadoop权威指南 ShowFileStatusTest的运行调试
- ABBYY FineReader识别图片中文本的教程
- 文件下载
- ERROR 1045 (28000)Access denied for user root localhost using passwordNO
- qualcomm QSD MSM APQ区别
- chromium浏览器的编译
- 2017 阿里巴巴矢量图标库 导入所选图标到jsp页面步骤
- 自定义Dialog,第二次点击item报The specified child already has a parent. You must call removeView() on the chil
- cmd打开某个目录下的程序
- 前端插件Bootstrap之下拉选学习(一)
- eclipse 等号左边代码自动补全,自动提示返回对象
- vi编辑器(1)