linux下如何在Python中使用MySQLdb模块

下载安装包：

MySQL-python-1.2.5.zip（下载地址：https://pypi.python.org/pypi/MySQL-python ）

setuptools-0.6c8.tar.gz（下载地址：http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c8.tar.gz）

1.下载安装setuptools
[root@localhost opt]#tar xzf setuptools-0.6c8.tar.gz
[root@localhost setuptools-0.6c8]# python setup.py build
[root@localhost setuptools-0.6c8]# python setup.py install
2.下载安装MySQL-python

[root@localhost opt]#unzip MySQL-python-1.2.5.zip
[root@localhost opt]# cd MySQL-python-1.2.5/
[root@localhost MySQL-python-1.2.5]$ sudo python setup.py build
[root@localhost MySQL-python-1.2.5]$ sudo python setup.py install

如果中间报很多奇奇怪怪的错，例如以下这种报错信息：

_mysql.c:30:26: 错误：structmember.h：没有那个文件或目录
_mysql.c:62: 错误：expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
_mysql.c:63: 错误：expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
_mysql.c:64: 错误：expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
_mysql.c:65: 错误：expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
_mysql.c:66: 错误：expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
_mysql.c:67: 错误：expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
_mysql.c:68: 错误：expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token

原因是因为没有安装mysql和python开发环境。
解决方法： sudo yum install python-devel mysql-devel
然后再安装一次即可成功
[root@localhost MySQL-python-1.2.5]$ python setup.py build
[root@localhost MySQL-python-1.2.5]$ python setup.py install

 

window系统下：

安装：MySQL-python-1.2.3.win-amd64-py2.7.exe（32位安装：MySQL-python-1.2.5.win32-py2.7.exe）