python连接pymysql主机目标无响应_pymysql 死活连不上

最新推荐文章于 2024-06-23 17:49:30 发布

weixin_39995774

最新推荐文章于 2024-06-23 17:49:30 发布

阅读量161

点赞数

文章标签： python连接pymysql主机目标无响应

本文链接：https://blog.csdn.net/weixin_39995774/article/details/111429621

版权

在尝试使用pymysql模块连接到180.76.183.79:3306的MySQL服务器时，遇到了 OperationalError。问题源于socket模块的getaddrinfo函数调用失败，返回了错误号11004。这通常意味着无法解析主机名或网络连接问题。

摘要由CSDN通过智能技术生成

该楼层疑似违规已被系统折叠隐藏此楼查看此楼

回复 Alfator :

Traceback (most recent call last):

File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 582, in connect

**kwargs)

File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37-32\lib\socket.py", line 707, in create_connection

for res in getaddrinfo(host, port, 0, SOCK_STREAM):

File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37-32\lib\socket.py", line 748, in getaddrinfo

for res in _socket.getaddrinfo(host, port, family, type, proto, flags):

socket.gaierror: [Errno 11004] getaddrinfo failed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "G:\001\python\hello1.py", line 5, in

conn=pymysql.connect(host='180.76.183.79:3306',user='root',password='123456',database='top')

File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\__init__.py", line 94, in Connect

return Connection(*args, **kwargs)

File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 327, in __init__

self.connect()

File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 629, in connect

raise exc

pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '180.76.183.79:3306' ([Errno 11004] getaddrinfo failed)")

关注