故障排除:错误111 - 无法连接到MySQL服务器
<p>我在Linux主机上安装了MySQL服务器,IP地址为192.168.1.100,但是当我尝试连接到这个IP时,总是出现错误(111)。但是使用localhost和127.0.0.1是可以的。</p>
<pre>beer@beer-laptop# ifconfig | grep "inet addr"
inet addr:127.0.0.1 Mask:255.0.0.0
inet addr:192.168.1.100 Bcast:192.168.1.255 Mask:255.255.255.0
beer@beer-laptop# mysql -ubeer -pbeer -h192.168.1.100
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.100' (111)
beer@beer-laptop# mysql -ubeer -pbeer -hlocalhost
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 160
Server version: 5.1.31-1ubuntu2 (Ubuntu)
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql>
beer@beer-laptop# mysql -ubeer -pbeer -h127.0.0.1
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 161
Server version: 5.1.31-1ubuntu2 (Ubuntu)
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql>
</pre>
<p>从另一台机器连接时也出现错误111。</p>
<pre>another@another-laptop# mysql -ubeer -pbeer -h192.168.1.100
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.100' (111)
</pre>
<p>在这种情况下,使用localhost或127.0.0.1与使用192.168.1.100之间有什么区别?我不知道如何从另一台机器连接到这个数据库。<br /><br />请帮忙,谢谢。</p><p><br /></p>