【python】mysqldb Windows安装

针对数据验证的项目，计划使用python实现一个sql查询原始数据验证数据正确性的小工具

原本电脑中有python2.7，现在得下载mysqldb模块，下载路径可在http://www.codegood.com/downloads，下载了MySQL-python-1.2.3.win-amd64-py2.7版本

接下来开始进行安装，点击安装出现了问题

搜索一下 Python version 2.7 required, which was not found in the registry 这个问题如何解决，发现此问题是由于安装的时候不能在注册表中识别出来python2.7，网上有脚本对注册表进行写入

## 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/[e-mail]/msg10512.htmlimport sysfrom _winreg import *# tweak as necessaryversion = sys.version[:3]installpath = sys.prefixregpath = "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()

运行.py文件后，可自动识别python2.7。当然，此问题也可以直接修改注册表键值

1. 打开注册表：win+R调出运行模块，输入regedit 打开注册表编辑器
2. python的第三方安装模块一般默认在HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Python\PythonCore\2.7\InstallPath路径下
3. 添加HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Python\PythonCore\2.7\InstallPath路径下的值

数值为python的安装路径

同样可进行安装

安装成功后，在编译器中import MySQLdb ，运行后发现，运行ERROR

ImportError: DLL load failed: %1 不是有效的 Win32 应用程序

因为本地系统为64位系统，觉得是否是pythondb的版本安装有误，重新在另外的网站下载了64位的pythondb，发现仍提示此错误

查看一下本地的python

发现python竟然是32bit

重新下载32bit的pythondb，再次运行，成功