默认root用户只允许本地连接,所以需要修改mysql库中user表中名为root的用户的host为“%”
select Host,User from user;
UPDATE mysql.user SET host = '%' WHERE user = 'root';
FLUSH PRIVILEGES;
默认root用户只允许本地连接,所以需要修改mysql库中user表中名为root的用户的host为“%”
select Host,User from user;
UPDATE mysql.user SET host = '%' WHERE user = 'root';
FLUSH PRIVILEGES;