1 python3.5 连接MySQL数据库需要安装PyMysql插件
插件下载地址:
https://pypi.python.org/pypi/PyMySQL#downloads代码示例:
import pymysql
conn = pymysql.connect(host=’localhost’, port=3306,user=’root’,passwd=’rusky’,db=’mysql’,charset=’UTF8’)
cur = conn.cursor()
cur.execute(“select version()”)
for i in cur:
print(i)
cur.close()
conn.close()