python脚本连接mysql数据库的方法

import pymysql

## 登录账号
host = "host_name"
user = "user_name"
password = "password"
database = "database_name"
port = port

conn = pymysql.connect(host, user, passwd, db, port) ## 登录数据库，返回连接

cursor = conn.cursor()
sql = "select var1, ..., varn from table_name where ..."
cursor.execute(sql)

data = cursor.fetchall() ##data为以元组为元素的元组
conn.commit()
cursor.close()
conn.close() ## 关闭连接