1,改表法

update user set host = ‘%’ where user = ‘root’;
FLUSH PRIVILEGES