连接mysql数据库驱动代码

import mysql.connector

# 创建数据库连接
try:
    connection = mysql.connector.connect(
        host='your_host',        # 数据库主机地址
        user='your_username',    # 数据库用户名
        password='your_password',# 数据库密码
        database='your_database' # 数据库名
    )

    if connection.is_connected():
        print('成功连接到MySQL数据库!')

        cursor = connection.cursor()

        # 执行SQL查询
        cursor.execute("SELECT DATABASE();")
        record = cursor.fetchone()
        print("You're connected to database: ", record)

except mysql.connector.Error as err:
    print(f"连接错误: {err}")
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL连接已关闭")