具体错误:
[root@localhost liuyuantao]# pip install mysql-pythonCollecting 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_configfind: ‘/proc/5155’: No such file or directoryfind: ‘/run/user/1000/gvfs’: Permission denied
果然mysql_config没有找到,是因为缺少mysql-devel,导致mysql_config丢失,安装mysql-devel即可。
yum install mysql-devel
若提示错误应该是MySQL的源存在问题,安装MySQL的源即可,具体见
mysql-devel安装成功之后,查看mysql_config是否存在
[root@localhost liuyuantao]# find / -name mysql_configfind: ‘/run/user/1000/gvfs’: Permission denied/usr/bin/mysql_config
在/usr/bin/mysql_config已经存在,使用pip安装mysql-python即可
root@localhost liuyuantao]# pip install mysql-pythonCollecting mysql-python Using cached MySQL-python-1.2.5.zipBuilding 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/ec87e092cfb38450fc91a62562055231deb0049a029054dc62Successfully built mysql-pythonInstalling collected packages: mysql-pythonSuccessfully installed mysql-python-1.2.5
接下来我们就可以使用python操作MySQL数据库了
[root@localhost liuyuantao]# pythonPython 2.7.5 (default, Aug 18 2016, 15:58:25) [GCC 4.8.5 20150623 (Red Hat 4.8.5-4)] on linux2Type "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)>>>