Python 操作 MySQL 数据库：使用 mysql-connector-python 库

import mysql.connector
from mysql.connector import Error
 
def connect_to_database(host, database, user, password):
    try:
        connection = mysql.connector.connect(host=host,
                                             database=database,
                                             user=user,
                                             password=password)
        if connection.is_connected():
            print("连接成功！")
            return connection
    except Error as e:
        print(f"连接失败：{e}")
    return None
 
def close_connection(connection):
    if connection is not None and connection.is_connected():
        connection.close()
        print("连接已关闭")
 
# 使用示例
host = 'localhost'
database = 'test_db'
user = 'testuser'
password = 'testpassword'
 
connection = connect_to_database(host, database, user, password)
# 在此处进行数据库操作，例如查询、插入等
# ...
 
# 关闭连接
close_connection(connection)

这段代码展示了如何使用mysql-connector-python库连接到MySQL数据库，并在成功连接后执行数据库操作。在操作完成后，关闭数据库连接是一个好习惯，以避免资源浪费或泄露。