登入mysql
mysql -uroot -p
进入mysql数据库
use mysql;
开启远程访问权限:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456'
强制刷新权限:
flush privileges;
关闭mysql:
exit;
开启防火墙:
查看已经开放的端口:
firewall-cmd --list-ports
开放端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重启防火墙:
systemctl reload firewalld