因为ip未授权,在navicat中执行
grant all privileges on *.* to 'root'@'192.168.1.119' identified by 'root' with grant option; 即可'root'@'192.168.1.119' 用户名@iproot:是密码
参考:https://blog.csdn.net/nicajonh/article/details/52311402
转载于:https://www.cnblogs.com/zqyw/p/10972012.html