mysql 数据库重名

SHOW DATABASES;

RENAME DATABASE old_database_name TO new_database_name;

import mysql.connector

def check_duplicate_databases(host, user, password):
    conn = mysql.connector.connect(host=host, user=user, password=password)
    cursor = conn.cursor()
    cursor.execute("SHOW DATABASES")
    databases = cursor.fetchall()
    database_names = [db[0] for db in databases]
    duplicates = set([name for name in database_names if database_names.count(name) > 1])
    return duplicates

if __name__ == "__main__":
    host = "localhost"
    user = "your_username"
    password = "your_password"
    duplicates = check_duplicate_databases(host, user, password)
    if duplicates:
        print("Duplicate databases found:", duplicates)
    else:
        print("No duplicate databases found.")