What is MySQL?

The world's most-deployed open-source relational database.

Visual explanation diagram · click steps to walk through it

Definition

MySQL is an open-source Relational Database Management System (RDBMS) that stores data in structured tables and speaks the SQL language. Originally released in 1995 by MySQL AB (Sweden), today it is owned by Oracle and powers a staggering chunk of the public internet — WordPress, Facebook, YouTube, Booking.com, and Shopify all run MySQL (or its drop-in fork, MariaDB) at scale.

How It Works

Under the hood MySQL is a long-running server process (mysqld) that accepts TCP connections (default port 3306). Each client connection sends SQL strings; the server parses them, builds an execution plan, runs the plan against the chosen storage engine (usually InnoDB), and streams rows back. Because the engine layer is pluggable, MySQL can mix transactional tables (InnoDB), in-memory tables (MEMORY), and archive tables (ARCHIVE) inside the same schema.

Example

sql
SELECT VERSION();

Expected Output

(Run in MySQL Workbench or `mysql` CLI — values depend on your data.)

Why It Matters

MySQL is the default first database every backend engineer learns. Knowing it cold unlocks 80% of web-stack jobs (LAMP, LEMP, MERN with MySQL replacing Mongo). Every cloud provider ships a managed MySQL — AWS RDS, Google Cloud SQL, Azure Database for MySQL — so the skills travel with you everywhere.

Key Takeaways

MySQL is a product; SQL is the language it speaks — don't confuse the two.
Default storage engine is InnoDB (since 5.5) — full ACID + row-level locking + foreign keys.
Connects over TCP/3306 — every client (CLI, Workbench, Python, Node) speaks the same wire protocol.
Open-source Community Edition is free forever; Oracle sells an Enterprise tier with extra tools.
MariaDB is a popular community fork — drop-in compatible for almost every workload.

Interview Questions

Practice Questions

Run SELECT VERSION(); on any MySQL server — note the major.minor.patch.
Open MySQL Workbench, connect to localhost, list databases via SHOW DATABASES;.
Spin up a free MySQL on db4free.net or PlanetScale and create your first database.

Pro Tips

Always run SHOW ENGINE INNODB STATUS\G when debugging a deadlock — it dumps the offending transactions.
Use mysqlsh (MySQL Shell) for serious work — it supports SQL, JavaScript, and Python modes in one terminal.
Pin your server's character set to utf8mb4 at install time — the legacy utf8 only stores 3-byte chars (no emoji).

// Try It Yourself · MySQL Playground

in-browser SQLite · no network

Run any SELECT, INSERT, JOIN or GROUP BY against the seeded users · products · orders tables — your changes are sandboxed and reset whenever you click Reset DB.

// editor · Ctrl + Enter to run

// result

Click Run to see results here.

// see seed schema (3 tables · 8 users · 8 products · 12 orders)

users (id, name, email, country, age, created_at)
products (id, name, price, stock, category)
orders (id, user_id → users.id, product_id → products.id, qty, total, created_at)

// Challenges0 / 6 solved

Each challenge is auto-graded — write the SQL, click Submit answer, and we'll compare your result-set to the canonical one.