mysql如何比对数据库

import mysql.connector

def compare_data(db1_config, db2_config, table_name):
    conn1 = mysql.connector.connect(**db1_config)
    conn2 = mysql.connector.connect(**db2_config)
    
    cursor1 = conn1.cursor()
    cursor2 = conn2.cursor()
    
    query = f"SELECT * FROM {table_name}"
    
    cursor1.execute(query)
    data1 = cursor1.fetchall()
    
    cursor2.execute(query)
    data2 = cursor2.fetchall()
    
    if data1 == data2:
        print("Data is the same.")
    else:
        print("Data is different.")
    
    cursor1.close()
    cursor2.close()
    conn1.close()
    conn2.close()

# 数据库配置示例
db1_config = {
    'host': 'localhost',
    'user': 'user1',
    'password': 'password1',
    'database': 'db1'
}

db2_config = {
    'host': 'localhost',
    'user': 'user2',
    'password': 'password2',
    'database': 'db2'
}

# 比对指定表的数据
compare_data(db1_config, db2_config, 'your_table_name')