c如何连接mysql

import mysql.connector

# 配置数据库连接参数
config = {
    'host': 'localhost',
    'port': 3306,
    'database': 'your_database',
    'user': 'your_username',
    'password': 'your_password'
}

try:
    # 建立连接
    connection = mysql.connector.connect(**config)
    
    if connection.is_connected():
        print("Connected to MySQL database")
        
        # 创建游标对象
        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"Error: '{err}'")
finally:
    # 关闭连接
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL connection is closed")