安装使用MySQL-Python

五 20th, 2011
发表评论 | Trackback

1).从: http://sourceforge.net/projects/mysql-python 下载MySQLdb库:最新得到的是MySQL-python-1.2.3.tar.gz
#mysql-python需要setuptools,如果没有先安装它
#http://pypi.python.org/pypi/setuptools#cygwin-mac-os-x-linux-other 根据自己的python版本下载相应的setuptools-0.6c8-py2.4.egg
#sh setuptools-0.6c11-py2.4.egg

2)安装

tar zxf MySQL-python-1.2.3.tar.gz
cd MySQL-python-1.2.3
python setup.py build
python setup.py install

3) 如果以apache cgi运行python脚本，那我们稍微修改下http.conf，添加如下

#python cgi
SetEnv PYTHON_EGG_CACHE /tmp
AddHandler cgi-script .cgi
<Directory "/var/www/html/python/cgi">
 Options Indexes FollowSymLinks Execcgi
 AllowOverride All
 Order allow,deny
 Allow from all
</Directory>

PYTHON_EGG_CACHE需要一个可以的目录用来存放MySQL_Python的cache
.cgi后缀作为cgi脚本运行: AddHandler cgi-script .cgi
为目录”/var/www/html/python/cgi” 添加Execcgi选项,并确保该目录可执行

4)测试脚本

#!/usr/bin/python
import cgitb
cgitb.enable(display=0, logdir="./tmp/")
print "Content-type: text/html\r\n"
import _mysql
db=_mysql.connect("localhost","root","passwd","test")
db.query("SELECT * FROM documents WHERE id=1")
r=db.store_result()
print r.fetch_row();
标签:
本文的评论功能被关闭了.