mysql怎么随机生成数据库

import random
import string
import pymysql

# 连接到MySQL数据库
connection = pymysql.connect(host='localhost',
                             user='your_username',
                             password='your_password',
                             database='your_database')

# 生成随机数据库名
db_name = ''.join(random.choice(string.ascii_letters) for i in range(10))

# 创建随机数据库
try:
    with connection.cursor() as cursor:
        sql = f"CREATE DATABASE {db_name}"
        cursor.execute(sql)
    connection.commit()
    print(f"随机数据库 '{db_name}' 创建成功！")
except Exception as e:
    print(f"创建随机数据库失败：{e}")

# 关闭数据库连接
connection.close()