解决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

原文地址:https://www.cnblogs.com/zqyw/p/10972012.html