mysql 5.7 修改密码

SHOW VARIABLES LIKE ‘validate_password%’;
set global validate_password_policy=LOW;
set global validate_password_length=4;
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘root’;

所有机器赋予权限
Grant all privileges on . to ‘root’@’%’ identified by ‘password’with grant option;
flush privileges;

firewall-cmd --state
systemctl stop firewalld.service