python3 连接mysql数据库

import pymysql

conn = pymysql.connect(host='10.2.3.5', port=3306, user='root', passwd='',db='mydata',charset='utf8')

cur = conn.cursor()

cur.execute("SELECT * FROM bankbase")

for r in cur.fetchall():

print(r)

cur.close()

conn.close()