centos 6.0 python lxml pyquery mysqldb

yum install python-devel libxslt-devel

 

1. 我的mysql是下载原码包自行编译安装到 /usr/local/mysql，在安装python的mysql模块时，执行安装命令会提示以下错误：

installsh: line 1: mysql_config: command not found
Traceback (most recent call last):
File “setup.py”, line 16, in ?
metadata, options = get_config()
File “/Users/farocco/MySQL-python-1.2.2/setup_posix.py”, line 43, in
get_config
libs = mysql_config(“libs_r”)
File “/Users/farocco/MySQL-python-1.2.2/setup_posix.py”, line 24, in
mysql_config
raise EnvironmentError, “%s not found” % mysql_config.path
EnvironmentError: mysql_config not found

这是由于它找不到mysql的安装位置，解决办法如下：

修改mysqldb包中的setup_posix.py文件，找到 mysql_config.path = option['mysql_config']，若当前系统mysql的安装路径为 /usr/local/mysql，则直接指定 mysql_config.path的位置，加入一行：

mysql_config.path = ‘/usr/local/mysql/bin/mysql_config’

再执行编译及安装命令即可

python setup.py build
python setup.py install

# python
# >>> import MySQLdb

如果报错
/usr/lib/python2.3/site-packages/MySQL_python-1.2.2-py2.3-linux-i686.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/lib/python2.3/site-packages/MySQL_python-1.2.2-py2.3-linux-i686.egg/_mysql.pyc, but /usr/local/src/MySQL-python-1.2.2 is being added to sys.path

原因是，install后MySQLdb模块已经被放到python的site-pachages目录中；但我在当前目录也存在相同的模块，所以可能会重复导入。只要切换到其他目录运行python就可以了。