自动创建mysql数据库

import mysql.connector

def create_database(db_name):
    try:
        # 连接到MySQL服务器
        conn = mysql.connector.connect(
            host="localhost",
            user="your_username",
            password="your_password"
        )
        cursor = conn.cursor()

        # 创建数据库
        cursor.execute(f"CREATE DATABASE {db_name}")

        print(f"Database {db_name} created successfully")

    except mysql.connector.Error as err:
        print(f"Error: '{err}'")

    finally:
        if conn.is_connected():
            cursor.close()
            conn.close()

# 调用函数创建数据库
create_database("my_new_database")

def database_exists(db_name):
    try:
        conn = mysql.connector.connect(
            host="localhost",
            user="your_username",
            password="your_password"
        )
        cursor = conn.cursor()
        cursor.execute(f"SHOW DATABASES LIKE '{db_name}'")
        result = cursor.fetchone()
        return result is not None
    except mysql.connector.Error as err:
        print(f"Error: '{err}'")
        return False
    finally:
        if conn.is_connected():
            cursor.close()
            conn.close()

def create_database(db_name):
    if not database_exists(db_name):
        try:
            conn = mysql.connector.connect(
                host="localhost",
                user="your_username",
                password="your_password"
            )
            cursor = conn.cursor()
            cursor.execute(f"CREATE DATABASE {db_name}")
            print(f"Database {db_name} created successfully")
        except mysql.connector.Error as err:
            print(f"Error: '{err}'")
        finally:
            if conn.is_connected():
                cursor.close()
                conn.close()
    else:
        print(f"Database {db_name} already exists")