mysql 别人无法连接问题

 use mysql;

update user set host = '%' where user = 'root'; flush privileges;

# 这里还是将密码设置为之前的设置的123456

alter user 'root'@'localhost' identified with mysql_native_password by '123456';

 use mysql;