Python 2.6.6安装MySQL-python模块

1.下载安装setuptools[root@localhost opt]#wget http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c8.tar.gz [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 install2.下载安装MySQL-python[root@localhost opt]# wget http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz/download [root@localhost opt]# cd MySQL-python-1.2.3/[root@localhost MySQL-python-1.2.3]# python setup.py build报错信息：..._mysql.c:2091: error: ‘r’ undeclared （first use in this function）_mysql.c:2091: error: ‘_mysql_ResultObject’ has no member named ‘result’_mysql.c:2092: error: ‘_mysql_ResultObject’ has no member named ‘result’_mysql.c: In function ‘_mysql_ResultObject_dealloc’:_mysql.c:2100: warning: implicit declaration of function ‘mysql_free_result’_mysql.c:2100: error: ‘_mysql_ResultObject’ has no member named ‘result’_mysql.c: At top level:_mysql.c:2331: error: ‘_mysql_ConnectionObject’ has no member named ‘open’_mysql.c:2338: error: ‘_mysql_ConnectionObject’ has no member named ‘converter’_mysql.c:2345: error: ‘_mysql_ConnectionObject’ has no member named ‘connection’_mysql.c:2352: error: ‘_mysql_ConnectionObject’ has no member named ‘connection’_mysql.c:2359: error: ‘_mysql_ConnectionObject’ has no member named ‘connection’_mysql.c:2422: error: ‘_mysql_ResultObject’ has no member named ‘converter’_mysql.c:2422: error: initializer element is not constant_mysql.c:2422: error: （near initialization for ‘_mysql_ResultObject_memberlist[0].offset’）_mysql.c: In function ‘_mysql_ConnectionObject_getattr’:_mysql.c:2444: error: ‘_mysql_ConnectionObject’ has no member named ‘open’error: command "gcc" failed with exit status 1解决方法：yum -y install mysql-devel libxml2 libxml2-dev libxslt* zlib gcc openssl[root@localhost MySQL-python-1.2.3]# python setup.py install3.测试
[root@localhost MySQL-python-1.2.3]# python Python 2.6.6 （r266:84292, May 24 2013, 21:09:02）[GCC 4.1.2 20080704 （Red Hat 4.1.2-46）] on linux2Type "help", "copyright", "credits" or "license" for more information.>>> import MySQLdb/usr/local/lib/python2.6/site-packages/MySQL_python-1.2.3-py2.6-linux-x86_64.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/local/lib/python2.6/site-packages/MySQL_python-1.2.3-py2.6-linux-x86_64.egg/_mysql.pyc, but /opt/MySQL-python-1.2.3 is being added to sys.path解决方法：[root@localhost MySQL-python-1.2.3]# cd ..[root@localhost opt]# python Python 2.6.6 （r266:84292, May 24 2013, 21:09:02）[GCC 4.1.2 20080704 （Red Hat 4.1.2-46）] on linux2Type "help", "copyright", "credits" or "license" for more information.>>> import MySQLdb>>>