📁 Python: Create Database in MySQL

📖 What is a Database?

Imagine you have a giant filing cabinet where you store all your important papers. Each drawer is organized with folders, and each folder has specific information.

A database is exactly like that filing cabinet, but for your computer!

Why Create a Database from Python?

⚙️ Getting Ready

Before we can create a database, we need to install the MySQL connector. Think of it like getting a key to open the database door.

🏗️ Create Your First Database

Let's create a database called myapp_db. It's super simple!

import mysql.connector

connection = mysql.connector.connect(
    host="localhost",
    user="root",
    password="secret"
)

cursor = connection.cursor()
cursor.execute("CREATE DATABASE myapp_db")

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

🔍 Check If Database Exists

Before creating a database, it's smart to check if it already exists. Here's how:

cursor.execute("SHOW DATABASES LIKE 'myapp_db'")
exists = cursor.fetchone() # Returns None if not found

if exists:
    print("✅ Database already exists!")
else:
    cursor.execute("CREATE DATABASE myapp_db")
    print("✅ Database created!")

🌐 Character Sets & UTF-8

Think of a character set like a language. UTF-8 is the universal language that supports ALL languages and even emojis! 😊

cursor.execute("""
    CREATE DATABASE IF NOT EXISTS myapp_db
    CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci
""")

⚠️ Handling Errors

Sometimes things go wrong. Here are the most common errors and how to handle them:

try:
    cursor.execute("CREATE DATABASE IF NOT EXISTS myapp_db")
    print("✅ Database ready!")
except mysql.connector.Error as e:
    print("❌ Error:", e)

💼 Real-World Example

Here's a complete example you can use in your projects:

import mysql.connector
from mysql.connector import Error

def create_my_database(db_name):
    """Create a database safely"""
    try:
        connection = mysql.connector.connect(
            host="localhost",
            user="root",
            password="secret"
        )
        cursor = connection.cursor()
        
        cursor.execute(f"""
            CREATE DATABASE IF NOT EXISTS {db_name}
            CHARACTER SET utf8mb4
            COLLATE utf8mb4_unicode_ci
        """)
        
        print(f"✅ Database '{db_name}' is ready!")
        return True
        
    except Error as e:
        print(f"❌ Oops! {e}")
        return False
    finally:
        cursor.close()
        connection.close()

# Use it!
create_my_database("myapp_db")

✅ Best Practices

🎮 Try It Yourself

Play with the code below. Click "Run" to see it in action!

🧠 Quick Quiz

Let's check what you learned!

❓ Frequently Asked Questions