python安装mysqldb模块

最新推荐文章于 2021-03-27 20:23:03 发布

转载最新推荐文章于 2021-03-27 20:23:03 发布 · 165 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://blog.51cto.com/songhl/2286485

文章标签：

#python

本文介绍了解决在64位系统中安装mysqldb模块遇到的问题，包括环境变量未找到或注册表错误的情况。通过创建并运行register.py脚本来注册Python环境，使得mysqldb模块能够在64位系统上成功安装。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysqldb模块已经很久没有在维护了,但是很多人习惯使用mysqldb.从官方下载的安装包是32位,而我们的系统都是64位的因此安装会找不到python的环境变量或会报下面错误

python version2.7 required,which was not found in the registry
解决方法:
创建一个register.py文件

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()

然后在doc下面执行此脚本即可
D:\>python egister.py
--- Python 2.7 is now registered!

然后就可以愉快的安装mysqldb模块了
下载地址:https://pypi.org/project/MySQL-python/
64位下载地址:https://www.codegood.com/downloads

转载于:https://blog.51cto.com/songhl/2286485