python3.6 连接mysql数据库问题

时间:2023-03-09 05:58:51
python3.6 连接mysql数据库问题

最近有个项目欲安装MySQL-python/1.2.5一直失败。

环境:

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