Python3 安装 MySQL-python错误解决

最新推荐文章于 2021-12-14 17:37:08 发布

Terry_Tsang

最新推荐文章于 2021-12-14 17:37:08 发布

阅读量1.1k

点赞数

分类专栏： python 文章标签： python

本文链接：https://blog.csdn.net/signmem/article/details/108317842

版权

python 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

目的

解决 python3 利用 pip 安装 MySQL-python 问题

参考错误信息

# /apps/svr/python3/bin/pip3 install MySQL-python
Collecting MySQL-python
  Using cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
    ERROR: Command errored out with exit status 1:
     command: /apps/svr/python3/bin/python3.8 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-3k3ejkx2/MySQL-python/setup.py'"'"'; __file__='"'"'/tmp/pip-install-3k3ejkx2/MySQL-python/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base pip-egg-info
         cwd: /tmp/pip-install-3k3ejkx2/MySQL-python/
    Complete output (7 lines):
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-install-3k3ejkx2/MySQL-python/setup.py", line 13, in <module>
        from setup_posix import get_config
      File "/tmp/pip-install-3k3ejkx2/MySQL-python/setup_posix.py", line 2, in <module>
        from ConfigParser import SafeConfigParser
    ModuleNotFoundError: No module named 'ConfigParser'
    ----------------------------------------
ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.
WARNING: You are using pip version 19.2.3, however version 20.2.2 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.

解决方法

先安装 configparser

# /apps/svr/python3/bin/pip3 install configparser
Collecting configparser
  WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError("HTTPSConnectionPool(host='pypi.org', port=443): Read timed out. (read timeout=15)")': /simple/configparser/
  Downloading https://files.pythonhosted.org/packages/4b/6b/01baa293090240cf0562cc5eccb69c6f5006282127f2b846fad011305c79/configparser-5.0.0-py3-none-any.whl
Installing collected packages: configparser
Successfully installed configparser-5.0.0

因为安装 MySQL 插件时候需要文件大写，因此需要进行改名

 mv /apps/svr/python3/lib/python3.8/site-packages/configparser.py  /apps/svr/python3/lib/python3.8/site-packages/ConfigParser.py

假如遇到下面错误

# /apps/svr/python3/bin/pip3 install MySQL-python
Collecting MySQL-python
  Using cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
    ERROR: Command errored out with exit status 1:
     command: /apps/svr/python3/bin/python3.8 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-79k6iaoo/MySQL-python/setup.py'"'"'; __file__='"'"'/tmp/pip-install-79k6iaoo/MySQL-python/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base pip-egg-info
         cwd: /tmp/pip-install-79k6iaoo/MySQL-python/
    Complete output (11 lines):
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/apps/svr/python3/lib/python3.8/site-packages/setuptools/__init__.py", line 20, in <module>
        from setuptools.dist import Distribution, Feature
      File "/apps/svr/python3/lib/python3.8/site-packages/setuptools/dist.py", line 35, in <module>
        from setuptools import windows_support
      File "/apps/svr/python3/lib/python3.8/site-packages/setuptools/windows_support.py", line 2, in <module>
        import ctypes
      File "/apps/svr/python3/lib/python3.8/ctypes/__init__.py", line 7, in <module>
        from _ctypes import Union, Structure, Array
    ModuleNotFoundError: No module named '_ctypes'
    ----------------------------------------
ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.
WARNING: You are using pip version 19.2.3, however version 20.2.2 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.

安装 RPM 后，重新编译 python 去解决

# yum install -y libffi-devel
Loaded plugins: fastestmirror, security
Setting up Install Process
Determining fastest mirrors
centos6                                                                                                | 3.4 kB     00:00
epel6                                                                                                  | 3.4 kB     00:00
Not using downloaded repomd.xml because it is older than what we have:
  Current   : Thu Feb 20 18:12:16 2020
  Downloaded: Thu Feb 20 18:11:01 2020
updates6                                                                                               | 2.8 kB     00:00
vip6                                                                                                   | 3.6 kB     00:00
vip6/primary_db                                                                                        | 302 kB     00:00
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction first to finish them.
--> Running transaction check
---> Package libffi-devel.x86_64 0:3.0.5-3.2.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================
 Package                         Arch                      Version                           Repository                  Size
==============================================================================================================================
Installing:
 libffi-devel                    x86_64                    3.0.5-3.2.el6                     centos6                     18 k

Transaction Summary
==============================================================================================================================
Install       1 Package(s)

Total download size: 18 k
Installed size: 21 k
Downloading Packages:
libffi-devel-3.0.5-3.2.el6.x86_64.rpm                                                                  |  18 kB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libffi-devel-3.0.5-3.2.el6.x86_64                                                                          1/1
  Verifying  : libffi-devel-3.0.5-3.2.el6.x86_64                                                                          1/1

Installed:
  libffi-devel.x86_64 0:3.0.5-3.2.el6

Complete!

安装 MySQL 插件

# /apps/svr/python3/bin/pip3 install MySQL-python
Collecting MySQL-python
  Using cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
Installing collected packages: MySQL-python
  Running setup.py install for MySQL-python ... done
Successfully installed MySQL-python-1.2.5
WARNING: You are using pip version 19.2.3, however version 20.2.2 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.

显示所有插件

# /apps/svr/python3/bin/pip3 list
Package      Version
------------ -------
configparser 5.0.0
MySQL-python 1.2.5
pip          19.2.3
setuptools   41.2.0