mysql配置dsn链接

import mysql.connector
from mysql.connector import Error

def create_connection():
    try:
        connection = mysql.connector.connect(
            host='localhost',
            database='mydatabase',
            user='myuser',
            password='mypassword'
        )
        if connection.is_connected():
            print("Connected to MySQL database")
        return connection
    except Error as e:
        print(f"Error while connecting to MySQL: {e}")
        return None

# 使用示例
connection = create_connection()
if connection:
    cursor = connection.cursor()
    cursor.execute("SELECT * FROM mytable")
    records = cursor.fetchall()
    for row in records:
        print(row)
    cursor.close()
    connection.close()