Python MySQL

MySQL Create Database

Creating databases

MySQL Create Database

To create a database in MySQL, use the "CREATE DATABASE" statement.

Create Database

import mysql.connector

mydb = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword"
)

mycursor = mydb.cursor()
mycursor.execute("CREATE DATABASE mydatabase")