1.修改mysql密码

i.mysql8
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘YUwei.12345’;

ii.mysql7

alter user ‘root’@’localhost’ identified by ‘123456’;
2.设置root账号远程访问
update user set host = ‘%’ where user = ‘root’;
3.设置防火墙放行3306端口
/sbin/iptables -I INPUT -p tcp –dport 3306 -j ACCEPT