使用多个连接从MySQL DB中查找最喜欢的数据库

import mysql.connector
from collections import Counter

def get_favorite_database(host, user, password):
    connections = []
    try:
        # 创建多个连接
        for _ in range(5):
            conn = mysql.connector.connect(host=host, user=user, password=password)
            connections.append(conn)
        
        databases = []
        for conn in connections:
            cursor = conn.cursor()
            cursor.execute("SHOW DATABASES")
            databases.extend([db[0] for db in cursor.fetchall()])
        
        # 统计数据库出现频率
        db_counter = Counter(databases)
        favorite_db = db_counter.most_common(1)[0][0]
        return favorite_db
    finally:
        # 关闭所有连接
        for conn in connections:
            conn.close()

# 使用示例
favorite_db = get_favorite_database('localhost', 'root', 'password')
print(f"最喜欢的数据库是: {favorite_db}")