python安装mysql库_python操作mysql数据库系列安装MySQLdb

一波三折&＃xff0c;先是pip命令出现问题&＃xff0c;然后各种方法尝试解决。然后是直接使用pip2命令安装报错&＃xff0c;mysql-python库安装再次出现问题。于是使用国内镜像的方式去安装&＃xff1a;pip2 install MySQL-python -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com 这个命令去安装&＃xff0c;总算链接上了&＃xff0c;下载下来了&＃xff0c;但是依然有报错。

pymongo 换成你想要安装的包&＃xff0c;&＃xff0c;别照搬照抄哈~~~~~~

报错如下&＃xff1a;

针对这个问题&＃xff0c;我们再次寻找解决方法&＃xff0c;报错原因是因为我们缺少了一个文件 MySQL_python-1.2.5-cp27-none-win_amd64.whl 这个文件的下载地址&＃xff1a;https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python

根据自己的操作系统版本选择下载的文件类型。我是选择的62位的。下载完成后&＃xff0c;我们使用pip命令去安装刚刚下载的mysql文件。

再当前目录我们执行&＃xff1a; pip2 install MySQL_python-1.2.5-cp27-none-win_amd64.whl 命令 如下图表示安装成功。

然后我们在去执行&＃xff1a;pip2 install MySQL-python -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com

发现已经安装成功了。然后我们进入到python2的交互模式&＃xff0c;执行 import MySQLdb 发现导入成功&＃xff01;&＃xff01;&＃xff01;&＃xff01;

方案二&＃xff1a;直接下载 MySQLdb for python&＃xff08;32/64位&＃xff09;下载地址&＃xff1a;http://www.codegood.com/archives/129

在安装MySQL-python-1.2.3.win-amd64-py2.7.exe时&＃xff0c;提示&＃xff1a;Python version 2.7 required&＃xff0c;which was not found in the registry

这是在注册表不能识别python2.7&＃xff0c;原因windows是64位&＃xff0c;安装的python是32位。怎么查看自己安装的python是多少位的呢&＃xff1f;因为32位、64位都可以在64位操作系统中安装&＃xff0c;所以年代久远的时候&＃xff0c;就不记得当时自己安装的python是32呢&＃xff0c;还是64了。查看非常之简单。输入平时我们检查是否有python环境的命令即可&＃xff1a;

C:\Users\Administrator>python

解决方法&＃xff1a;

1.新建一个register.py文件&＃xff0c;将如下代码copy进去&＃xff1a;

#

# 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&＃64;python.org/msg10512.html

import sys

from _winreg import *

# tweak as necessary

version &＃61; sys.version[:3]

installpath &＃61; sys.prefix

regpath &＃61; "SOFTWARE\\Python\\Pythoncore\\%s\\" % (version)

installkey &＃61; "InstallPath"

pythonkey &＃61; "PythonPath"

pythonpath &＃61; "%s;%s\\Lib\\;%s\\DLLs\\" % (

installpath, installpath, installpath

)

def RegisterPy():

try:

reg &＃61; OpenKey(HKEY_CURRENT_USER, regpath)

except EnvironmentError as e:

try:

reg &＃61; 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) &＃61;&＃61; installpath and

QueryValue(reg, pythonkey) &＃61;&＃61; pythonpath):

CloseKey(reg)

print "&＃61;&＃61;&＃61; Python", version, "is already registered!"

return

CloseKey(reg)

print "*** Unable to register!"

print "*** You probably have another Python installation!"

if __name__ &＃61;&＃61; "__main__":

RegisterPy()

2.定位到该文件所在目录运行python register.py

说明python2.7已经注册成功。

3.再执行MySQLdb安装程序&＃xff0c;则会自动识别&＃xff0c;并安装成功了。

注意&＃xff1a;目前Mysqldb这个模块 不支持python3环境&＃xff0c;所以我们的安装教程是以python2为主。