连接mysql提示：“Host ‘172.23.0.1‘ is not allowed to connect to this MySQL server“

null,  message from server: "Host '172.23.0.1' is not allowed to connect to this MySQL server"

use mysql;

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

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

flush privileges;