两个域名可以用两个数据库

import mysql.connector

# 连接到数据库
def connect_to_db(host, user, password, database):
    try:
        conn = mysql.connector.connect(
            host=host,
            user=user,
            password=password,
            database=database
        )
        return conn
    except mysql.connector.Error as err:
        print(f"Error connecting to MySQL: {err}")
        return None

# 查询数据
def query_data(conn, sql):
    cursor = conn.cursor()
    cursor.execute(sql)
    result = cursor.fetchall()
    cursor.close()
    return result

# 示例使用
host = "localhost"
user = "root"
password = "password"
database1 = "db1"
database2 = "db2"

conn1 = connect_to_db(host, user, password, database1)
conn2 = connect_to_db(host, user, password, database2)

if conn1 and conn2:
    sql1 = "SELECT * FROM table1"
    sql2 = "SELECT * FROM table2"
    result1 = query_data(conn1, sql1)
    result2 = query_data(conn2, sql2)
    print(result1, result2)
    conn1.close()
    conn2.close()