如何使用Python连接MySQL数据库？

pip install mysql-connector-python

import mysql.connector

cnx = mysql.connector.connect(
    user='<your_username>',
    password='<your_password>',
    host='<your_host>',
    database='<your_database>'
)

cursor = cnx.cursor()

query = "SELECT * FROM <your_table>"
cursor.execute(query)

results = cursor.fetchall()

cursor.close()
cnx.close()

import mysql.connector

cnx = mysql.connector.connect(
    user='<your_username>',
    password='<your_password>',
    host='<your_host>',
    database='<your_database>'
)

cursor = cnx.cursor()

query = "SELECT * FROM <your_table>"
cursor.execute(query)

results = cursor.fetchall()

for row in results:
    print(row)

cursor.close()
cnx.close()