mysql python cp36_python3.6 连接mysql数据库问题

环境：

win7

python3.6.2

报错信息如下：

Creating library build\temp.win32-3.6\Release\_mysql.cp36-win32.lib and o

bject build\temp.win32-3.6\Release\_mysql.cp36-win32.exp

mysqlclient.lib(typelib.obj) : error LNK2001: unresolved external symbol ___

iob_func

mysqlclient.lib(viosslfactories.obj) : error LNK2001: unresolved external sy

mbol ___iob_func

mysqlclient.lib(my_winfile.obj) : error LNK2001: unresolved external symbol

___iob_func

mysqlclient.lib(my_messnc.obj) : error LNK2001: unresolved external symbol _

__iob_func

mysqlclient.lib(client.obj) : error LNK2001: unresolved external symbol ___i

ob_func

mysqlclient.lib(my_thr_init.obj) : error LNK2001: unresolved external symbol

___iob_func

mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol ___

iob_func

mysqlclient.lib(default.obj) : error LNK2001: unresolved external symbol ___

iob_func

mysqlclient.lib(default.obj) : error LNK2001: unresolved external symbol _pr

intf

build\lib.win32-3.6\_mysql.cp36-win32.pyd : fatal error LNK1120: 2 unresolve

d externals

error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\B

IN\\link.exe' failed with exit status 1120

----------------------------------------

Command "d:\programs\python36-32\python.exe -u -c "import setuptools, tokenize;_

_file__='C:\\Users\\code65\\AppData\\Local\\Temp\\pip-build-utscjthe\\mysql-pyth

on\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace(

'\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record

C:\Users\code65\AppData\Local\Temp\pip-784mj8vx-record\install-record.txt --sing

le-version-externally-managed --compile" failed with error code 1 in C:\Users\co

de65\AppData\Local\Temp\pip-build-utscjthe\mysql-python\

按好多网上解决办法都是失败的，原来由于 MySQLdb 模块还不支持 Python3.x，所以 Python3.x 如果想连接MySQL需要安装 pymysql 模块。

参考自http://www.cnblogs.com/hank-chen/p/6624299.html

D:\Python>pip install pymysql

Collecting pymysql

Downloading PyMySQL-0.7.11-py2.py3-none-any.whl (78kB)

38% |████████████▌                   | 30kB 111kB/s eta 0:00:01

51% |████████████████▋               | 40kB 117kB/s eta 0:0

64% |████████████████████▊           | 51kB 127kB/s eta

77% |█████████████████████████       | 61kB 151kB/s

90% |█████████████████████████████   | 71kB 165

100% |████████████████████████████████| 81kB

179kB/s

Installing collected packages: pymysql

Successfully installed pymysql-0.7.11