开放:
firewall-cmd --zone=public --add-port=3306/tcp --permanent
mysql -uroot -p(密码)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '(密码)' WITH GRANT OPTION;
FLUSH PRIVIEGES;
quit;
systemctl restart frewalld
关闭:
firewall-cmd --zone=public --remove-port=3306/tcp --permanent
mysql -uroot -p(密码)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '(密码)' WITH GRANT OPTION;
FLUSH PRIVIEGES;
quit;
systemctl restart frewalld