2007-08-15

[MySQL] Can't connect to MySQL server on '192.168.3.100' (111)

$ mysql -ufoo -pbar -h192.168.3.100 mydb
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.3.100' (111)

默认情况下 mysql 只 listen 到 127.0.0.1 上, 修改 `/etc/mysql/my.cnf', 注释掉下面一行即可:

bind-address = 127.0.0.1

No comments: