Python中最连接Mysql常用的驱动是 (转载)
mysql-python :mysql的C语言的驱动
mysql-connector:msql官方的驱动
pymysql:python语言的驱动
我这里安装的是 mysql-python
终端中执行
pip install mysql-python
运气好的的话,直接就成功了,我遇到了一下问题,最终找到了解决方案,原因及解决方案如下,供参考
问题1:mysql_config not found
终端打印出:
Collecting mysql-python
Downloading MySQL-python-1.2.5.zip (108kB)
100% |████████████████████████████████| 110kB 30kB/s
Complete output from command python setup.py egg_info:
sh: mysql_config: command not found
Traceback (most recent call last):
File "<string>", line 20, in <module>
File "/private/tmp/pip-build-NP8J3v/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 /private/tmp/pip-build-NP8J3v/mysql-python
解决方法,执行:
ln -s /usr/local/mysql/bin/mysql_config /usr/local/bin/mysql_config
原因
找不到mysql_config一般是由于通过lnmp.org或者其他方式安装mysql以后mysql_config是在/usr/local/mysql/bin/里面,这里面的文件不是在任意位置都可以访问的,而指令是
将mysql_config链接到/usr/local/bin目录下