Host ‘192.168.1.104‘ is not allowed to connect to this mysql server

解决方法

use mysql;
select host,user from user;
update user set Host='%' where User='root';
select host,user from user;
flush privileges;

执行完更新语句，在查看root用户对应的主机是否由‘localhost’转为‘%’