python里安装mysql有错_CentOS7使用pip安装mysql-python出错解决方案

具体错误：

[root@localhost liuyuantao]# pip install mysql-python

Collecting mysql-python

Downloading MySQL-python-1.2.5.zip (108kB)

100% |████████████████████████████████| 112kB 77kB/s

Complete output from command python setup.py egg_info:

sh: mysql_config: command not found

Traceback (most recent call last):

File "", line 1, in

File "/tmp/pip-build-7Pn8K6/mysql-python/setup.py", line 17, in

metadata, options = get_config()

File "setup_posix.py", line 43, in get_config

libs = mysql_config("libs_r")

File "setup_posix.py", line 25, in mysql_config

raise EnvironmentError("%s not found" % (mysql_config.path,))

EnvironmentError: mysql_config not found

----------------------------------------

Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-7Pn8K6/mysql-python/

上面的错误是由于缺少mysql_config文件导致，查看下mysql_config文件是否存在

[root@localhost liuyuantao]# find / -name mysql_config

find: ‘/proc/5155’: No such file or directory

find: ‘/run/user/1000/gvfs’: Permission denied

果然mysql_config没有找到，是因为缺少mysql-devel，导致mysql_config丢失，安装mysql-devel即可。

yum install mysql-devel

mysql-devel安装成功之后，查看mysql_config是否存在

[root@localhost liuyuantao]# find / -name mysql_config

find: ‘/run/user/1000/gvfs’: Permission denied

/usr/bin/mysql_config

在/usr/bin/mysql_config已经存在，使用pip安装mysql-python即可

root@localhost liuyuantao]# pip install mysql-python

Collecting mysql-python

Using cached MySQL-python-1.2.5.zip

Building wheels for collected packages: mysql-python

Running setup.py bdist_wheel for mysql-python ... done

Stored in directory: /root/.cache/pip/wheels/38/a3/89/ec87e092cfb38450fc91a62562055231deb0049a029054dc62

Successfully built mysql-python

Installing collected packages: mysql-python

Successfully installed mysql-python-1.2.5

接下来我们就可以使用python操作MySQL数据库了

[root@localhost liuyuantao]# python

Python 2.7.5 (default, Aug 18 2016, 15:58:25)

[GCC 4.8.5 20150623 (Red Hat 4.8.5-4)] on linux2

Type "help", "copyright", "credits" or "license" for more information.

>>> import MySQLdb

>>> dir(MySQLdb)

['BINARY', 'Binary', 'Connect', 'Connection', 'DATE', 'DATETIME', 'DBAPISet', 'DataError', 'DatabaseError', 'Date', 'DateFromTicks', 'Error', 'FIELD_TYPE', 'IntegrityError', 'InterfaceError', 'InternalError', 'MySQLError', 'NULL', 'NUMBER', 'NotSupportedError', 'OperationalError', 'ProgrammingError', 'ROWID', 'STRING', 'TIME', 'TIMESTAMP', 'Time', 'TimeFromTicks', 'Timestamp', 'TimestampFromTicks', 'Warning', '__all__', '__author__', '__builtins__', '__doc__', '__file__', '__name__', '__package__', '__path__', '__revision__', '__version__', '_mysql', 'apilevel', 'connect', 'connection', 'constants', 'debug', 'escape', 'escape_dict', 'escape_sequence', 'escape_string', 'get_client_info', 'paramstyle', 'release', 'result', 'server_end', 'server_init', 'string_literal', 'test_DBAPISet_set_equality', 'test_DBAPISet_set_equality_membership', 'test_DBAPISet_set_inequality', 'test_DBAPISet_set_inequality_membership', 'thread_safe', 'threadsafety', 'times', 'version_info']

>>> MySQLdb.version_info

(1, 2, 5, 'final', 1)

>>>