mysql数据对比插件

import mysql.connector

def compare_databases(host1, user1, password1, database1, host2, user2, password2, database2):
    conn1 = mysql.connector.connect(host=host1, user=user1, password=password1, database=database1)
    conn2 = mysql.connector.connect(host=host2, user=user2, password=password2, database=database2)

    cursor1 = conn1.cursor()
    cursor2 = conn2.cursor()

    cursor1.execute("SHOW TABLES")
    tables1 = cursor1.fetchall()

    cursor2.execute("SHOW TABLES")
    tables2 = cursor2.fetchall()

    # 对比表结构
    for table in tables1:
        if table in tables2:
            # 对比表数据
            pass
        else:
            print(f"Table {table} exists only in database1")

    for table in tables2:
        if table not in tables1:
            print(f"Table {table} exists only in database2")

    cursor1.close()
    cursor2.close()
    conn1.close()
    conn2.close()

# 示例调用
compare_databases('localhost', 'user1', 'password1', 'db1', 'localhost', 'user2', 'password2', 'db2')