我的客户端是win7, mysql服务端是阿里云上的vps:centos 6,mysql里的用户已经有远程访问权限了
+-----------+--------+
| host | user |
+-----------+--------+
| % | XXX |
| % | root |
| 127.0.0.1 | root |
| localhost | root |
+-----------+--------+
iptables 已经让我关闭了,
netstat 查看端口 远程ip应该可以访问的
tcp 0 0 *:mysql *:* LISTEN
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
但是我在win7 用telnet ip 3306 提示无法连接 telnet 80端口就有反映
用navicat连接也不行
mysql 账户 我用了root和另一个具有远程权限的都不行
/etc/my.cnf 如下:
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
bind-address = 0.0.0.0
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
+-----------+--------+
| host | user |
+-----------+--------+
| % | XXX |
| % | root |
| 127.0.0.1 | root |
| localhost | root |
+-----------+--------+
iptables 已经让我关闭了,
netstat 查看端口 远程ip应该可以访问的
tcp 0 0 *:mysql *:* LISTEN
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
但是我在win7 用telnet ip 3306 提示无法连接 telnet 80端口就有反映
用navicat连接也不行
mysql 账户 我用了root和另一个具有远程权限的都不行
/etc/my.cnf 如下:
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
bind-address = 0.0.0.0
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M