我有一个运行在Red hat 5.7上的标准MySQL服务器。我编辑了/etc/my.cnf来指定绑定地址作为我的服务器的公共IP地址。
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks ;
# to do so, uncomment this line:
# symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
bind-address=171.67.88.25
port=3306我也重启了我的防火墙
sudo /sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT
/sbin/service iptables save当从远程计算机连接时,我发出问题
mysql -u jeffrey -p --host=171.67.88.25 --port=3306 --socket=/var/lib/mysql/mysql.sock但收到一个错误:
ERROR 2003 (HY000): Can't connect to MySQL server on '171.67.88.25' (113).
有人知道为什么吗?我还要求网络管理员为此盒子打开端口3306