#1045 - Access denied for user 'root'@'localhost' (using password: YES)
来源:互联网 发布:女声变男声软件 编辑:程序博客网 时间:2024/04/30 07:15
操作系统:windows xp
问题描述:
在控制台shell下修改了root的密码,然后在http://localhost/phpmyadmin下无法登录了
报错:#1045 - Access denied for user 'root'@'localhost' (using password: YES)
操作重现:
mysql -u root -p
****** #以前的密码
use mysql ;
update user set password=PASSWORD('new_passwd') where user = 'root' ; #设置你新的密码
flush privileges ;
然后就在phpmyadmin无法登录了
问题原因:
这是因为在phpmyadmin的配置文件中,原有的密码并没有改变,所以导致登录不上去
解决方法:
找到你XAMPP存放目录:我的:F:/xampp/phpMyAdmin/config.inc.php
修改红色标注的地方,这个地方应该是你以前的密码,把它修改为你的新密码,然后重新访问就可以了。
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045 - Access denied for user 'root'@'localhost'(using password:YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045-Access denied for user 'root'@'localhost'(using password:YES)
- Access denied for user 'root'@'localhost' (using password: YES) 1045
- 1045 access denied for user\'root\'@\'localhost\' using password yes
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045 access denied for user ’root’@’localhost’ using password yes
- 1045, "Access denied for user 'root'@'localhost' (using password: YES)"
- 1045 access denied for user 'root'@'localhost' (using password yes)
- Access denied for user 'root'@'localhost' (using password: YES) 问题解决
- 解决'Access denied for user 'root'@'localhost' (using password: YES)'
- Oracle 行列转换 总结
- flex资料
- 一个漂亮的指令机
- 正则表达式
- C#数据库学习笔记(二)
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- silverlight页面保存为PDF
- Spring MVC 四 基础学习
- No result defined for Action and result success
- js 控制 页面控件 显示 隐藏
- 转发和重定向的区别
- lbs/gprs/wifi信息查看
- ADB 基础知识
- nginx与apache详细性能对比