use mysql;
select host, user, authentication_string, plugin from user;
CREATE USER ‘root’@’%’ IDENTIFIED BY ‘root’;
set global validate_password.policy=0;
set global validate_password.length=1;
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘root’;
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’;
flush privileges;
添加端口:firewall-cmd --zone=public --add-port=3306/tcp --permanent
重载防火墙:firewall-cmd --reload
重启服务 systemctl stop mysqld.service systemctl start mysqld.service