mysql远程连接 Host * is not allowed to connect to this MySQL server

进入数据库 ，将root的用户的host 属性  设置为%
mysql -u root -p
 
mysql>use mysql;
 
mysql>update user set host ="%" where user ="root";
 
mysql>flush privileges;

 

重新加载权限

flush privileges;