首先:
import pymysql
#创建连接
conn = pymysql.connect(host='ip地址',
port=3306,
user='username',
passwd='paasword',
db='database');
#创建游标
cursor = conn.cursor();
#查询
cursor.execute("SELECT * FROM users");#可以定义一个变量接收返回行数
rows = cursor.fetchall();
for row in rows:
print(row );