EF 连接mysql Authentication to host '' for user 'root' using method 'mysql_n(远程登录mysql失败)
来源:互联网 发布:什么编程语言最好学 编辑:程序博客网 时间:2024/05/16 19:45
本机的mysql数据库中有两条user='root'的记录,将其中一条host='localhost'的host修改为'%'后,虽然可以通过远程访问数据库了,但是使用localhost或者127.0.0.1又无法访问数据库了。
经过一番折腾,发现可以通过创建用户的方法来解决这个问题。不需要修改user表中的任何数据,在本地用root登陆mysql后,执行下面的语句,创建用户名为'root',密码为'123456'的用户。执行完以后,查看user表,发现新增了一条host='%',user='root'的记录,并且各项权限与其它'root'一样,再次使用192.168.1.13进行访问,发现可以正常访问了。
grant all privileges on *.* to Root identified by "c#Sys123";
flush privileges;
1
2
3
4
grant
all
on
*.*
to
root identified
by
'123456'
with
grant
option
;
0 0
- EF 连接mysql Authentication to host '' for user 'root' using method 'mysql_n(远程登录mysql失败)
- MySQL远程登录root用户失败--MySQL ERROR 1045 (28000): Access denied for user 'root' - Solution
- Authentication to host '' for user '' using method 'mysql_native_password' failed with message
- mySQL 5.7版 解决密码登录失败Access denied for user 'root'@'localhost' (using password: NO)
- MySQL 5.7版 解决密码登录失败Access denied for user 'root'@'localhost' (using password: NO)
- mySQL 5.7版 解决密码登录失败mysql中Access denied for user 'root'@'localhost' (using password:YES)
- mysql连接失败access denied for user root @localhost
- 远程 mysql access denied for user 'root'@'%' to database xxxx
- mysql报ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password)错误或者远程用户不能登录
- 解决用Mysql 使用navicate远程连接数据库出现1045 access denied for user 'root'@'localhost' using password yes
- 解决用远程连接mysql数据库出现1045 access denied for user 'root'@'localhost' using password yes
- MySQL远程连接提示Accesss denied for user 'root'@'此处为你自己的ip'(using password:YES)
- MySQL 'root'@'localhost'无法登录|Access denied for user ‘root’@’localhost’ (using password: YES)”
- root用户连接mysql数据库出错 1045 access denied for user 'root'@'localhost' using password yes
- MySQL for mac 连接报错:Access denied for user 'root'@'localhost' (using password: YES)
- linux下登录mysql报错“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO“)
- MySQl登录错误:ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
- mysql登录:access denied for user 'root@localhost'(using password: YES)
- [POJ 1830] 开关问题 高斯消元
- PHP魔术方法之__call与__callStatic方法
- Android ANR-Keydispatch timeout
- ios常用的ID(IDFA IDFV MAC UDID openUDID )
- Servlet(及tomcat)之一
- EF 连接mysql Authentication to host '' for user 'root' using method 'mysql_n(远程登录mysql失败)
- HDU 1171 Big Event in HDU(多重背包)
- Button点击事件实现页面跳转的两种方法
- Java面试宝典:42个面试题总结!
- 创建一台55分钟后会自动终止的EC2实例
- 图像处理概述
- Java内存泄露的理解与解决
- source在线调试sass自动保存在服务器上
- 20150802厦门大学华为校园提前批招聘机试体验题三:Word Maze(单词迷宫)