Python的MySQLdb模块安装

痛定思痛。 2022-09-30 13:48 348阅读 0赞

http://www.cnblogs.com/rollenholt/archive/2012/05/07/2487137.html

系统:ubuntu 11.10

mysql:直接apt-get安装的，version:5.1.62

到官方下载[MySQL for Python][]

然后解压，打开README：

里面有安装过程：

*t**a**r**x**f**z**M**y**S**Q**L*−*p**y**t**h**o**n*−1.2.1.*t**a**r*.*g**z* tarxfzMySQL−python−1.2.1.tar.gz cd MySQL-python-1.2.1  
\# edit site.cfg if necessary\# edit site.cfg if necessary python setup.py build  
$ sudo python setup.py install \# or su first

不过在python setup.py build时报错：

ImportError: No module named setuptools

ubuntu下安装：

sudo apt-get install python-setuptools

***python-setuptools ： Python Distutils Enhancements (setuptools compatibility)***

然后再次python setup.py build，又报错：

EnvironmentError: mysql\_config not found

因为mysql\_config是属于MySQL开发用的文件，而使用apt-get安装的MySQL是没有这个文件的，于是在包安装器里面寻找

sudo apt-get install libmysqld-dev

***libmysqld-dev ： MySQL embedded database development files***

再次运行python setup.py build，报错：

building ‘\_mysql’ extension  
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -Dversion\_info=(1,2,3,’final’,0) -D\_\_version\_\_=1.2.3 -I/usr/include/mysql -I/usr/include/python2.7 -c \_mysql.c -o build/temp.linux-i686-2.7/\_mysql.o -DBIG\_JOINS=1 -fno-strict-aliasing -DUNIV\_LINUX -DUNIV\_LINUX  
In file included from \_mysql.c:29:0:  
pymemcompat.h:10:20: fatal error: Python.h: No such file or directory

解决方案，

sudo apt-get install python-dev

***python-dev ： header files and a static library for Python (default)***

然后就按照README里的：

*p**y**t**h**o**n**s**e**t**u**p*.*p**y**b**u**i**l**d* pythonsetup.pybuild sudo python setup.py install

测试：

>>>import MySQLdb

没有报错即可。

参考：

[http://blog.csdn.net/guzicheng/article/details/5884106][http_blog.csdn.net_guzicheng_article_details_5884106]

[http://be-evil.org/post-185.html][http_be-evil.org_post-185.html]

[http://hi.baidu.com/hevensun/blog/item/3b6e313fe8515df154e7238f.html][http_hi.baidu.com_hevensun_blog_item_3b6e313fe8515df154e7238f.html]

[http://stackoverflow.com/questions/1449130/how-to-install-mysqldb-package-importerror-no-module-named-setuptools][http_stackoverflow.com_questions_1449130_how-to-install-mysqldb-package-importerror-no-module-named-setuptools]

[http://www.cnblogs.com/objdump/archive/2011/11/03/mysql\_python\_install\_error.html][http_www.cnblogs.com_objdump_archive_2011_11_03_mysql_python_install_error.html]

[MySQL for Python]: http://sourceforge.net/projects/mysql-python/
[http_blog.csdn.net_guzicheng_article_details_5884106]: http://blog.csdn.net/guzicheng/article/details/5884106
[http_be-evil.org_post-185.html]: http://be-evil.org/post-185.html
[http_hi.baidu.com_hevensun_blog_item_3b6e313fe8515df154e7238f.html]: http://hi.baidu.com/hevensun/blog/item/3b6e313fe8515df154e7238f.html
[http_stackoverflow.com_questions_1449130_how-to-install-mysqldb-package-importerror-no-module-named-setuptools]: http://stackoverflow.com/questions/1449130/how-to-install-mysqldb-package-importerror-no-module-named-setuptools
[http_www.cnblogs.com_objdump_archive_2011_11_03_mysql_python_install_error.html]: http://www.cnblogs.com/objdump/archive/2011/11/03/mysql_python_install_error.html