环境如下
MySQL安装在192.168.137.100 Ubuntu 12.04 LTS
客户端在 192.168.137.200 win7
客户端希望访问MySQL数据库,会出现如下错误“ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.137.100' (10061)”
C:\>mysql -h 192.168.137.100 -u root -p
Enter password: ****
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.137.100' (10061)
解除地址绑定
这是因为缺省情况下MySQL是只允许本机登录的。修改MySQL的配置文件位于/etc/mysql/my.cnf,不进行地址绑定
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1 <---注释掉这一行
再次进行访问,错误变成了我这个” ERROR 1130 (HY000): Host 'abbuggy-PC.mshome.net' is not allowed to connect to this MySQL server“