MySql 1045 access denied for user 'root'@'localhost' using password yes错误解决方法
来源:互联网 发布:js二级下拉菜单 编辑:程序博客网 时间:2024/06/11 05:46
今天在jdbc连接MySql中出现 Access denied for user 'root'@'localhost' (using password: YES)的错误
试了下navicat 中连接mysql也是出现 1045 access denied for user 'root'@'localhost' using password yes
去网上找了下答案:原来是远程登录被拒绝,要改一个表数据的属性让他可以远程登录
解决方法如下,执行命令:
mysql>use mysql;
mysql>select host ,user from user;
查看结果是不是root用户仅允许本地 localhost 登录,是的话,就要修改它的host为%,表示任意IP地址都可以登录
mysql> update user set host ='%' where user='root';
执行完后root对应的host成了%,表示可以任意IP地址登录了。
最后:
mysql> flushprivileges
把缓存flush掉
最后在navicat连接时
输入mysql的密码就可以连接成功
0 0
- MySql 1045 access denied for user 'root'@'localhost' using password yes错误解决方法
- Ubuntu mysql 的Access denied for user 'root'@'localhost' (using password: YES错误解决方法
- mysql中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)解决方法
- MySQl登录错误:ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
- mysql 错误解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql出现1045 - Access denied for user 'root'@'localhost' (using password: YES)错误
- mysql出现:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 错误
- mysql错误:1045 access denied for user 'root'@'localhost' using password yes
- navicat(MySql)错误1045 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)
- 【FRDM-KW41Z学习笔记】FRDM-KW41Z开发板入门
- Spring mvc <mvc:resources ***/> 作用
- zookeeper实现原理
- 用双缓存机制异步加载图片
- Oracle AWR报告提取方法
- MySql 1045 access denied for user 'root'@'localhost' using password yes错误解决方法
- spark厦大---Word2Vec--spark.ml
- 浅谈C#中virtual和abstract的区别
- 生成器 Generators
- Scala匿名函数语法
- 二五、vue仿百度搜索框
- MySQL ibdata1文件迁移
- 第5章 定时器Timer
- spark厦大---标签和索引的转化:StringIndexer- IndexToString-VectorIndexer