使用的是PyMySql组件

pip3 install PyMySQL

代码

#!/usr/bin/python3import pymysql # 打开数据库连接conn = pymysql.connect ( host=‘127.0.0.1‘, port=3306, user=‘root‘, password=‘12345‘, database=‘mysql‘, charset=‘utf8‘)cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) # 返回字典数据类型 # 定义将要执行的sql语句# sql = ‘select user from user;‘sql = "SELECT user FROM user"# 拼接并执行sql语句cursor.execute(sql) try: cursor.execute(sql) # 获取所有记录列表 results = cursor.fetchall() for x in results: print(x)except: print ("Error: unable to fetch data")cursor.close()conn.close()