MYSQL远程连接出现113错误是什么问题

cclylycc

防火墙已经全部关了

20块红包求解决

cclylycc

大佬们》。。

cclylycc

求解

alienware

pip install cymysql==0.9.4

cclylycc

alienware 发表于 2018-6-4 11:09
pip install cymysql==0.9.4

还是不行：

  File "/root/shadowsocksr/db_transfer.py", line 248, in thread_db
    rows = db_instance.pull_db_all_user()
  File "/root/shadowsocksr/db_transfer.py", line 383, in pull_db_all_user
    db=self.cfg["db"], charset='utf8')
  File "/usr/lib/python2.7/site-packages/cymysql/__init__.py", line 85, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib/python2.7/site-packages/cymysql/connections.py", line 245, in __init__
    self._connect()
  File "/usr/lib/python2.7/site-packages/cymysql/connections.py", line 412, in _connect
    raise OperationalError(2003, "Can't connect to MySQL server on %r (%s)" % (self.host, e.args[0]))
OperationalError: (2003, "Can't connect to MySQL server on u'172.1xx.1xx.xx' (113)")

dforel

ip地址是对的吗？端口是对的吗？要不要试试写内网ip地址

cclylycc

dforel 发表于 2018-6-10 11:34
ip地址是对的吗？端口是对的吗？要不要试试写内网ip地址

IP是对的，端口也对，防火墙也关了，是连接的远程mysql。

cclylycc

求大佬帮忙解决下

dforel

cclylycc 发表于 2018-6-10 12:35
求大佬帮忙解决下

加我qq。我给你远程试一下

shiro

1. 检查防火墙
2. 如果是root，配置文件解禁root远程登录