Python MySQL Create Database

Create your first database - Like making a new folder!

🏗️ Create Your First Database!

A database is like a big folder where you keep related information. Let's make one! 


cursor.execute("CREATE DATABASE my_school")
print("Database created! 🎉")
1
Command
Super
Easy
Quick
To Do

What is a Database?

Think of a database like:

  • 📁 A folder on your computer
  • 🏪 A store with different sections
  • 📚 A library with organized books
  • 🗃️ A filing cabinet with drawers

Create Your First Database

Basic Database Creation 

import mysql.connector

# Connect to MySQL
connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='yourpass'
)

cursor = connection.cursor()

# Create a database
cursor.execute("CREATE DATABASE my_school")

print("✅ Database 'my_school' created!")

cursor.close()
connection.close()

The Safe Way (Recommended)

Safe Database Creation 

import mysql.connector

try:
    connection = mysql.connector.connect(
        host='localhost',
        user='root',
        password='yourpass'
    )
    
    cursor = connection.cursor()
    
    # Safe way - won't crash if database exists
    cursor.execute("CREATE DATABASE IF NOT EXISTS my_school")
    
    print("✅ Database is ready!")
    
except mysql.connector.Error as error:
    print(f"❌ Error: {error}")
    
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("🔒 Connection closed")

💡 Why "IF NOT EXISTS"?

This prevents errors if the database already exists. It's like saying "create it only if it's not there already".

Database Naming Rules

✅

Good Names

  • my_school
  • online_store
  • blog_site
  • user_data
❌

Bad Names

  • 123school (starts with number)
  • my-school (has dash)
  • my school (has space)
  • SELECT (reserved word)

See All Your Databases

List All Databases 

import mysql.connector

connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='yourpass'
)

cursor = connection.cursor()

# Show all databases
cursor.execute("SHOW DATABASES")
databases = cursor.fetchall()

print("📁 Your databases:")
for db in databases:
    print(f"  - {db[0]}")

cursor.close()
connection.close()

Create Multiple Databases

Make Several Databases 

import mysql.connector

# List of databases to create
databases = ['my_school', 'my_store', 'my_blog']

try:
    connection = mysql.connector.connect(
        host='localhost',
        user='root',
        password='yourpass'
    )
    
    cursor = connection.cursor()
    
    for db_name in databases:
        cursor.execute(f"CREATE DATABASE IF NOT EXISTS {db_name}")
        print(f"✅ {db_name} - Ready!")
    
    print("🎉 All databases created!")
    
except mysql.connector.Error as error:
    print(f"❌ Error: {error}")
    
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()

Make It Super Easy

Easy Database Creator 

import mysql.connector

def create_database(name):
    """Simple function to create a database"""
    try:
        connection = mysql.connector.connect(
            host='localhost',
            user='root',
            password='yourpass'
        )
        
        cursor = connection.cursor()
        cursor.execute(f"CREATE DATABASE IF NOT EXISTS {name}")
        
        print(f"✅ Database '{name}' is ready!")
        return True
        
    except mysql.connector.Error as error:
        print(f"❌ Error: {error}")
        return False
        
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# Use it like this:
create_database('my_first_db')
create_database('my_second_db')

Simple Tips

🛡️ Use IF NOT EXISTS

Prevents errors if database already exists

📝 Good Names

Use lowercase and underscores

🔍 Check First

Use SHOW DATABASES to see what exists

🔒 Close Connections

Always close when done

🧠 Quick Check

Which command creates a database?

What's the safe way to create a database?