pip 安装 pymysql 报错 OSError: HTTPSConnectionPool

原创已于 2023-01-29 18:11:10 修改 · 698 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#pip #mysql #python

于 2023-01-29 18:10:50 首次发布

在Python中连接MySQL时，安装pymysql库出现OSError报错。解决办法是通过临时指定国内镜像源进行安装，以加速并解决下载问题。可以参考更多源地址来找到适合的下载源。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

python中连接mysql，需要安装pymysql
安装时报错提示

pip install pymysql

Collecting pymysql
  WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.HTTPSConnection object at 0x103288f90>: Failed to establish a new connection: [Errno 8] nodename nor servname provided, or not known')': /packages/4f/52/a115fe175028b058df353c5a3d5290b71514a83f67078a6482cff24d6137/PyMySQL-1.0.2-py3-none-any.whl
  WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.HTTPSConnection object at 0x103289ed0>: Failed to establish a new connection: [Errno 8] nodename nor servname provided, or not known')': /packages/4f/52/a115fe175028b058df353c5a3d5290b71514a83f67078a6482cff24d6137/PyMySQL-1.0.2-py3-none-any.whl
  WARNING: Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.HTTPSConnection object at 0x10328a790>: Failed to establish a new connection: [Errno 8] nodename nor servname provided, or not known')': /packages/4f/52/a115fe175028b058df353c5a3d5290b71514a83f67078a6482cff24d6137/PyMySQL-1.0.2-py3-none-any.whl
  WARNING: Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.HTTPSConnection object at 0x10328bbd0>: Failed to establish a new connection: [Errno 8] nodename nor servname provided, or not known')': /packages/4f/52/a115fe175028b058df353c5a3d5290b71514a83f67078a6482cff24d6137/PyMySQL-1.0.2-py3-none-any.whl
  WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.HTTPSConnection object at 0x10323a410>: Failed to establish a new connection: [Errno 8] nodename nor servname provided, or not known')': /packages/4f/52/a115fe175028b058df353c5a3d5290b71514a83f67078a6482cff24d6137/PyMySQL-1.0.2-py3-none-any.whl
ERROR: Could not install packages due to an OSError: HTTPSConnectionPool(host='files.pythonhosted.org', port=443): Max retries exceeded with url: /packages/4f/52/a115fe175028b058df353c5a3d5290b71514a83f67078a6482cff24d6137/PyMySQL-1.0.2-py3-none-any.whl (Caused by NewConnectionError('<pip._vendor.urllib3.connection.HTTPSConnection object at 0x10327cf90>: Failed to establish a new connection: [Errno 8] nodename nor servname provided, or not known'))

解决办法：更换下载源

临时指定使用国内的源地址

pip install pymysql -i https://pypi.tuna.tsinghua.edu.cn/simple

更多源地址参考

清华：https://pypi.tuna.tsinghua.edu.cn/simple
阿里云：http://mirrors.aliyun.com/pypi/simple
中国科技大学 https://pypi.mirrors.ustc.edu.cn/simple
华中理工大学：http://pypi.hustunique.com/
山东理工大学：http://pypi.sdutlinux.org/ 
豆瓣：http://pypi.douban.com/simple/