首先需要安装pymysql模块 方法:打开cmd,pip install pymysql
具体连接代码如下
import pymysql
conn = pymysql.connect(host='localhost',user='root',password='密码',db='web',charset='utf8')
cur = conn.cursor()
sql = "SELECT * FROM user"
cur.execute(sql)
u = cur.fetchall()
conn.close()
for i in u:
print(i)
输出结果