安装MySQLdb遇到的问题

来源:互联网 发布:泰迪狗狗衣服秋冬淘宝 编辑:程序博客网 时间:2024/05/16 12:40

问题1:

安装MySQL-python-1.2.3.win-amd64-py2.7.exe,时提示:Python version 2.7 required, which was not found in the registry

解决方案:(转自:http://blog.csdn.net/w2cschool/article/details/40520233)

这是在注册表不能识别python2.7,原因windows是64位,安装的Python是32位
备注:MySQLdb for python (32/64位)下载;http://www.codegood.com/archives/129;不同版本都有,选择自己需要的py
解决方法是:
1.在任意盘符文件夹新建一个register.py文件
将如下代码拷贝进去:
[python] view plain copy
#  
# script to register Python 2.0 or later for use with win32all  
# and other extensions that require Python registry settings  
#  
# written by Joakim Loew for Secret Labs AB / PythonWare  
#  
# source:  
# http://www.pythonware.com/products/works/articles/regpy20.htm  
#  
# modified by Valentine Gogichashvili as described in http://www.mail-archive.com/distutils-sig@python.org/msg10512.html  
   
import sys  
   
from _winreg import *  
   
# tweak as necessary  
version = sys.version[:3]  
installpath = sys.prefix  
   
regpath = "SOFTWARE\\Python\\Pythoncore\\%s\\" % (version)  
installkey = "InstallPath"  
pythonkey = "PythonPath"  
pythonpath = "%s;%s\\Lib\\;%s\\DLLs\\" % (  
    installpath, installpath, installpath  
)  
   
def RegisterPy():  
    try:  
        reg = OpenKey(HKEY_CURRENT_USER, regpath)  
    except EnvironmentError as e:  
        try:  
            reg = CreateKey(HKEY_CURRENT_USER, regpath)  
            SetValue(reg, installkey, REG_SZ, installpath)  
            SetValue(reg, pythonkey, REG_SZ, pythonpath)  
            CloseKey(reg)  
        except:  
            print "*** Unable to register!"  
            return  
        print "--- Python", version, "is now registered!"  
        return  
    if (QueryValue(reg, installkey) == installpath and  
        QueryValue(reg, pythonkey) == pythonpath):  
        CloseKey(reg)  
        print "=== Python", version, "is already registered!"  
        return  
    CloseKey(reg)  
    print "*** Unable to register!"  
    print "*** You probably have another Python installation!"  
   
if __name__ == "__main__":  
    RegisterPy()  


  
    
2.定位到该文件所在目录,运行python register.py
提示如下:
--- Python 2.7 is now registered!
说明python2.7已经注册成功

3.在执行MySQLdb,则会自动识别,并安装成功


问题2:win7 64位,安装mysqldb 后提示:ImportError DLL load failed: %1 不是有效的 Win32 应用程序

解决方案:(转自:http://blog.csdn.net/seven_zhao/article/details/16945043)

由于安装的32位的 MySQL-Python-1.2.3.win32-py2.exe,,只要改成64位版本的就可以了。

如果没有找到,可以使用如下链接下载:

32位:http://download.csdn.NET/detail/seven_zhao/6607621

64位:http://download.csdn.net/detail/seven_zhao/6607625

也可以在如下地址下载:

http://www.codegood.com/downloads


原创粉丝点击