MYSQL问题:Access denied for user 'root'@'localhost' (using password:YES)
来源:互联网 发布:python写上位机 wifi 编辑:程序博客网 时间:2024/06/16 19:00
今天发现连接mysql出现了Access denied for user ‘root’@’localhost’ (using password:YES)的提示,造成cmd窗口也连不上数据库,逆向工程等所有要连接数据库的操作都失败了,网上找了找,总结了以下方法。
原因是root帐户默认不开放远程访问权限,所以需要修改一下相关权限。
解决方案:
1.打开MySQL目录(我的是在C:\Program Files (x86)\MySQL\MySQL Server 5.5)下的my.ini文件,编辑,在文件的最后添加一行“skip-grant-tables”,保存并关闭文件。
打开服务,重启MySQL服务。
2.通过命令行进入MySQL的BIN目录,(我的BIN目录为:C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin)
在命令行中输入“mysql -u root -p 123456”,即可成功连接数据库。
完成以上步骤,eclipse也可成功连接MySQL了。
阅读全文
0 0
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- MySql Access denied for user 'root'@'localhost' (using password: YES)
- mysql access denied for user'root'@'localhost' using password yes
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- mysql:Access denied for user 'root'@'localhost' (using password:YES)
- MySQL:Access denied for user 'root'@'localhost' (using password:YES)
- MySQL问题 Access denied for user 'root'@'localhost' (using password: YES)
- mysql启动问题access denied for user 'root'@'localhost'(using password:YES)
- mysql启动问题access denied for user 'root'@'localhost'(using password:YES)
- mysql启动问题access denied for user 'root'@'localhost'(using password:YES)
- mysql 安装问题 access denied for user 'root'@'localhost' using password yes/no
- 解决MySQL #1045 - Access denied for user 'root'@'localhost' (using password: YES) 的问题
- wampserver登陆mysql出现#1045 - Access denied for user 'root'@'localhost' (using password: YES) 问题
- 238,安装mysql出现Access denied for user 'root'@'localhost' (using password: YES)的问题
- MySQL问题:Access denied for user 'root'@'localhost' (using password: YES)
- mysql启动问题access denied for user 'root'@'localhost'(using password:YES)
- mysql启动问题access denied for user 'root'@'localhost'(using password:YES)
- Candy
- oracle中where条件后用in这样子查询后变慢
- mysql出现错误“ Every derived table must have its own alias”
- LVM逻辑卷管理 练习
- C++ 最小化到托盘
- MYSQL问题:Access denied for user 'root'@'localhost' (using password:YES)
- codevs 1014 装箱问题
- hdu 1847 巴什博奕
- 大数据资源整理 ---持续更新
- 线程监控
- Mybatis 全局配置文件 SqlMapConfig.xml 的配置内容
- 创建Http Proxy
- HTML 表格
- JSP基础(二十)——JSTL标签库简介