Python连接MySQL数据库的两种方式

1. 使用mysql-connector库

• 安装mysql-connector库

pip install mysql-connector-python

• 连接MySQL数据库

import mysql.connector

# 建立数据库连接
connection = mysql.connector.connect(
    host="主机名（一般为localhost）",
    user="用户名",
    password="密码",
    database="数据库名"
)
# 获取游标
cursor = connection.cursor()
# 执行SQL查询
cursor.execute("SELECT * FROM your_table_name")
# 获取查询结果
result = cursor.fetchall()
# 遍历结果
for row in result:
    print(row)
# 关闭游标和连接
cursor.close()
connection.close()

2. 使用pymysql库

• 安装pymysql库

pip install pymysql

• 连接MySQL数据库

import pymysql

# 建立数据库连接
connection = pymysql.connect(
   host="主机名（一般为localhost）",
    user="用户名",
    password="密码",
    database="数据库名"
    cursorclass=pymysql.cursors.DictCursor
)
# 获取游标
cursor = connection.cursor()
# 执行SQL查询
cursor.execute("SELECT * FROM your_table_name")
# 获取查询结果
result = cursor.fetchall()
# 遍历结果
for row in result:
    print(row)
# 关闭游标和连接
cursor.close()
connection.close()