mysql 远程连接debian8中的mysql数据库的,报错。
mysql -h IP -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111)
可能原因:
vi /etc/mysql/my.cnf
找到
[mysqld]
bind-address = 127.0.0.1
注释掉bind-address
重启mysql
/etc/init.d/mysql restart
参考http://www.2cto.com/database/201204/127400.html
您的支持,是我持续创作的动力!!!!