简介
近期要用python连接mysql,在安装MYSQLdb这个包时有了很多的坑,这里记录一下
安装
使用pip install python-mysql指令进行该包的安装,会发现爆出如下的错误:
Collecting MySQL-python
Using cached MySQL-python-1.2.5.zip
Complete output from command python setup.py egg_info:
sh: mysql_config: 未找到命令
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/tmp/pip-build-GMAz73/MySQL-python/setup.py", line 17, in <module>
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-GMAz73/MySQL-python/
从报错中我们可以看出是因为mysql_config这个文件不存在,我们执行一下find / -name mysql_config
,发现又爆出如下权限不足的错误:
find: ‘/run/user/1000/gvfs’: 权限不够
我们去执行如下的指令去跳过这些权限不够的文件
find / -name mysql_config 2> /dev/null
,发现mysql_config这个文件确实是不存在的.我用的linux为centos,上网查询应该安装mysql-devel,使用yum安装mysql-devel,
yum install mysql-devel
安装完成之后,我们再次执行find操作,发现config出现在/usr/bin/mysql_config下.
这是我们再次执行
pip install mysql-python
已经可以成功安装MYSQLdb了