python 连接mysql数据库API安装

pymysql下载地址：

https://pypi.python.org/pypi/PyMySQL3/0.5 找到PyMySQL3-0.5.tar.gz (md5)下载，

解压之后，运行cmd，切换到PyMySQL3-0.5目录

输入python setup.py install，执行安装

import pymysql
 
conn = pymysql.connect(host="127.0.0.1",port=3306,user="test",passwd="12345",db="test",charset="utf8")
 
cur = conn.cursor()
 
sql = "select * from user"
 
cur.execute(sql)
 
rows = cur.fetchall()
 
#print(rows)
 
for dr in rows:
    print(dr)