mysql开启远程访问并添加3306端口

1：登陆mysql

mysql -u root -p

2：设置允许访问的地址

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.123' IDENTIFIED BY 'password' WITH GRANT OPTION;

3：刷新权限

flush privileges;

4：防火墙打开端口3306

firewall-cmd --zone=public --add-port=3306/tcp --permanent

5：重启防火墙

firewall-cmd --reload

6：查看已经开放的端口

firewall-cmd --list-ports