日期:2014-05-16  浏览次数:20669 次

cygwin中安装MySQL Python module
前面比较简单,直接按图索骥
1、安装cygwin
2、下载mysql包编译安装client端:
      tar -xvzf mysql-5.0.37.tar.gz
      cd mysql-5.0.37
      配置、编译、安 装
      ./configure --without-server
      make && make install

3、编译安装MySQLdb
    tar -xvzf MySQL-python-1.2.2.tar.gz
    cd MySQL-python-1.2.2

    首先修改MySQLdb的编译配置文件:site.cfg,在MySQL-python-1.2.2目录下。

    找到[options]项进行如下修改:

    放开mysql_config = /usr/local/bin/mysql_config一行,屏蔽#registry_key = SOFTWARE\MySQL AB\MySQL Server 5.0一行,因为cygwin属于类Linux不是Windows。

   由于我们用在PC机上所以设置embedded为False。

    设置threadsafe为False;我们尽量采用静态编译,static设为True。

    最后的[options]如下:


[options]
# embedded: link against the embedded server library
# threadsafe: use the threadsafe client
# static: link against a static library (probably required for embedded)
embedded = False
threadsafe = False
static = True
# The path to mysql_config.
# Only use this if mysql_config is not on your PATH, or you have some weird
# setup that requires it.<
mysql_config = /usr/local/bin/mysql_config
# The Windows registry key for MySQL.
# This has to be set for Windows builds to work.
# Only change this if you have a different version.
#registry_key = SOFTWARE\MySQL AB\MySQL Server 5.0





cd MySQL-python-1.2.2
python setup.py build
python setup.py install
在安装过程中可能会要求下载setuptools,按要求下载即可。

安装完成在python测试运行的时候遇到问题,死活说没有权限,

报ImportError: Permission denied错误

查询相关资料发现,是cygwin下需要修改用户目录下的那个cache的_mysql.dll权限

路径如下:

/home/用户名/.python-eggs/MySQL_python-1.2.2-py2.5-cygwin-1.5.25-i686.eg
g-tmp/_mysql.dll

chmod +x _mysql.dll 后再次执行。ok ,pass


参考文章:
http://blog.csdn.net/kernelspirit/archive/2007/04/18/1568884.aspx
http://www.velocityreviews.com/forums/t484678-python-eggs-on-cygwin.html