如何配置连接mysql

pip install mysql-connector-python

import mysql.connector

# 配置数据库连接参数
config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': '127.0.0.1',  # 或者你的数据库服务器IP地址
    'database': 'your_database',
    'port': '3306'  # 默认端口号
}

try:
    # 建立连接
    connection = mysql.connector.connect(**config)
    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连接已关闭")

GRANT ALL PRIVILEGES ON your_database.* TO 'your_username'@'your_host';
FLUSH PRIVILEGES;