解决方案:
默认情况下,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