python连接mysql数据库的步骤

import pymysql

conn = pymysql.connect(host='数据库地址', port=3306, user='用户名', password='密码', database='数据库名称')

cursor = conn.cursor()

sql = 'SELECT * FROM 表名'
cursor.execute(sql)

results = cursor.fetchall()

cursor.close()
conn.close()

import pymysql

# 建立数据库连接
conn = pymysql.connect(host='数据库地址', port=3306, user='用户名', password='密码', database='数据库名称')

# 创建游标对象
cursor = conn.cursor()

# 执行SQL语句
sql = 'SELECT * FROM 表名'
cursor.execute(sql)

# 获取执行结果
results = cursor.fetchall()

# 输出结果
for row in results:
    print(row)

# 关闭游标和连接
cursor.close()
conn.close()