异常 1130 host is not allowed to connect to

找到mysql库

在mysql数据下操作： 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH   PRIVILEGES;

此方法可以让  Navicat Premium工具连上，但192.168.1.44机器上的java程序连不上。

如果指指定192.168.1.44机器上和java程序也可以连上可用

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.44' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH   PRIVILEGES;