MySQL + SQL · Lesson 31

MySQL Setup and First Commands

Getting Started with MySQL

To start, install MySQL Server (and optionally MySQL Workbench or use XAMPP for a quick local setup). Then connect and run your first commands.

Your First Commands

SHOW DATABASES;            -- list databases
CREATE DATABASE school;    -- make one
USE school;                -- select it
SHOW TABLES;               -- list tables in it

Tip

On Windows, XAMPP gives MySQL + phpMyAdmin in one click — great for students and PHP projects.

Summary

Install MySQL Server (or XAMPP for local dev).
First commands: SHOW DATABASES, CREATE DATABASE, USE, SHOW TABLES.