cenos mysql开启远程连接

首先确定是否有iptables

安装：yum install -y iptables

授权配置mysql远程连接：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

flush privileges;

查看端口：

 

mysql> show global variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3306  |
+---------------+-------+
1 row in set (0.01 sec)

开启端口查看另一篇文章

https://mp.csdn.net/postedit/81290250