Host ‘192.168.32.169‘ is not allowed to connect to this MySQL server

• • 问题：
  • 解决方法：

#前情概要

虚拟机采用CentOS8

sudo yum install -y mysql
sudo yum install -y mysql-server
// 服务启动
sudo systemctl start mysqld
sudo systemctl enable mysqld
//mysql初始化
mysql_secure_installation
//添加防火墙规则
sudo firewall-cmd --zone=public --add-service=mysql --permanent
sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent
sudo firewall-cmd --reload

Host ‘192.168.32.169’ is not allowed to connect to this MySQL server

登录mysql

mysql -uroot -p123456
mysql> use mysql;
mysql> update user set host = '%' where user = 'root' and host='localhost';
mysql> GRANT ALL ON *.* TO 'root'@'%' ;
mysql> flush privileges;