#前情概要
虚拟机采用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;