Python 安装 mysqlclient、mysql-mython

如果您的目标机器mysql是编译安装的请阅读下文，如若不是请使用yum 安装相关mysql组件

错误提示

[root@hinink /]# pip3 install mysqlclient
Looking in indexes: http://pypi.douban.com/simple
Collecting mysqlclient
  Downloading http://pypi.doubanio.com/packages/a5/e1/e5f2b231c05dc51d9d87fa5066f90d1405345c54b14b0b11a1c859020f21/mysqlclient-2.0.1.tar.gz (87 kB)
     |████████████████████████████████| 87 kB 3.7 MB/s 
    ERROR: Command errored out with exit status 1:
     command: /bin/python3 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-t_gdy06b/mysqlclient/setup.py'"'"'; __file__='"'"'/tmp/pip-install-t_gdy06b/mysqlclient/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 /tmp/pip-pip-egg-info-4pkvsm3z
         cwd: /tmp/pip-install-t_gdy06b/mysqlclient/
    Complete output (12 lines):
    /bin/sh: mysql_config: command not found
    /bin/sh: mariadb_config: command not found
    /bin/sh: mysql_config: command not found
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-install-t_gdy06b/mysqlclient/setup.py", line 15, in <module>
        metadata, options = get_config()
      File "/tmp/pip-install-t_gdy06b/mysqlclient/setup_posix.py", line 65, in get_config
        libs = mysql_config("libs")
      File "/tmp/pip-install-t_gdy06b/mysqlclient/setup_posix.py", line 31, in mysql_config
        raise OSError("{} not found".format(_mysql_config_path))
    OSError: mysql_config not found
    ----------------------------------------
ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.

• 原因 由于环境变量导致无法安装

解决

1. pypi 下载源码包

https://pypi.org/project/mysqlclient/

2. 设置环境变量

[root@hinink /]# PATH="$PATH":/usr/local/mysql/bin

3. 安装

[root@hinink /]#  python3 setup.py install

4. 附件
   mysqlclient-2.0.1.tar.gz (87.8 kB)