access denied for user 'root'@'localhost'(using password:YES)解决方案
来源:互联网 发布:淘宝新店铺怎样排前 编辑:程序博客网 时间:2024/03/29 21:39
安装Mysql后利用SQLyogEnt启动是提示“access denied for user 'root'@'localhost'(using password:YES)”,开始我还为是因为是密码问题,后来上网查了查才知道root权限问题,我想可能是因为win7系统我在安装时没用以管理员身份进行安装,所以root角色没有权限,从网上找了一个解决方案解决了,在这里记录一下:
1. 管理员登陆系统,停止mysql服务或者结束mysqld-nt进程;
2. 进入命令行,来到mysql的安装目录.假设安装目录为 d:\mysql\ , CMD进入命令行;
3. 运行 D:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld-nt --skip-grant-tables启动mysql,关闭权限的检查;
4. 运行 D:\Program Files\MySQL\MySQL Server 5.5\bin\mysqladmin -u root flush-privileges password "newpassword" 重设root密码;
5. 重新启动mysql服务;
参考:http://www.cnblogs.com/gogly/p/3293328.html
0 0
- 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) 解决方案
- 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) 解决方案
- 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)解决方案
- 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)解决方案
- 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)'
- access denied for user 'root'@'localhost' using password yes
- access denied for user 'root'@'localhost' using password yes
- 搜狐狐友怎样查看朋友圈
- 概率图模型-原理与技术 第三章 贝叶斯网表示 习题与编程
- [POJ2104/HDU2665]Kth Number-主席树-可持久化线段树
- 网络编程 - boost::asio优雅的退出
- Android_APP 常用图标尺寸规范
- access denied for user 'root'@'localhost'(using password:YES)解决方案
- 利用多线程解决生成券性能问题
- python常用模块
- 数据库结构比较工具
- poj 3481--Double Queue
- Java集合Map,set, list 之间的转换
- oracle学习总结--------oracle数据库的启动流程
- ubuntu wangka
- redis 报错