解决MySql Access denied for user 'root'@'192.168.1.119' to databse 的问题

因为ip未授权,在navicat中执行

  • grant all privileges on *.* to 'root'@'192.168.1.119' identified by 'root' with grant option; 即可
  • 'root'@'192.168.1.119'    用户名@ip
  • root:是密码

参考:https://blog.csdn.net/nicajonh/article/details/52311402

posted @ 2019-06-04 10:25  念宇儿  阅读(815)  评论(0编辑  收藏  举报