ERROR 2003 (HY000): Can't connect to MySQL server on 'IP address' (111)

解决方案:

默认情况下,MySQL服务器配置为不允许任何远程访问。

只允许从'localhost' 即 '127.0.0.1'IP地址连接。

此配置可以在MySQL主配置文件“/etc/MySQL/my.cnf”中找到:

bind-address           = 127.0.0.1

要使MySQL Server允许从任何远程IP地址连接,
将修改上面的行修改“0.0.0.0”
或者注释整个行:

bind-address           = 0.0.0.0
OR
#bind-address           = 127.0.0.1

重新启动MySQL服务器:

# service mysql restart
[ ok ] Stopping MySQL database server: mysqld.
[ ok ] Starting MySQL database server: mysqld ..
[info] Checking for tables which need an upgrade, are corrupt or were 
not closed cleanly..

问题

无法连接MySQL服务器,错误消息:

ERROR 2003 (HY000): Can't connect to MySQL server on 'IP address' (111)
日期:2020-07-07 20:54:48 来源:oir作者:oir