阿里云ecs上安装了mysql但是外网访问不了
阿里云ecs上安装了mysql但是外网访问不了
步骤
使用yum安装mysql server
启动mysql
grant 一个用户 允许所有host访问
重起mysql
这是mysql库中的user表
mysql> select host,user from user;
+-------------------------+---------+
| host | user |
+-------------------------+---------+
| % | dbadmin |
| %.%.%.% | icyfc |
| 127.0.0.1 | root |
| iz8vb8il84z4prxo5ljzqjz | |
| iz8vb8il84z4prxo5ljzqjz | root |
| localhost | |
| localhost | root |
+-------------------------+---------+[root@iZ8vb8il84z4prxo5ljzqjZ ~]# netstat -tunpl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:9000 0.0.0.0:* LISTEN 2630/php-fpm
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 32007/mysqld
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 2805/nginx
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 15354/sshd
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1555/master
udp 0 0 172.26.13.175:123 0.0.0.0:* 1464/ntpd
udp 0 0 127.0.0.1:123 0.0.0.0:* 1464/ntpd
udp 0 0 0.0.0.0:123 0.0.0.0:* 1464/ntpd
udp 0 0 0.0.0.0:68 0.0.0.0:* 1060/dhclient
[root@iZ8vb8il84z4prxo5ljzqjZ ~]# iptables -L
Chain INPUT (policy ACCEPT)
target prot opt source destination
ACCEPT tcp -- anywhere anywhere tcp dpt:mysql
Chain FORWARD (policy ACCEPT)
target prot opt source destination
Chain OUTPUT (policy ACCEPT)
target prot opt source destination 
