我在Linux服务器上安装了MySQL服务,IP地址为192.168.1.100。但是当我尝试连接到该IP时,总是出现错误(111),但使用localhost和127.0.0.1却可以正常连接。
以下是我的ifconfig命令输出:
以下是我的ifconfig命令输出:
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我使用以下命令连接MySQL:
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)从另一台机器连接时,也会出现错误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>
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)在这种情况下,使用localhost/127.0.0.1和192.168.1.100之间有什么区别呢?我不知道如何从另一台机器连接到此数据库。请帮忙解决,谢谢!