MySQL — Get Started

Installing MySQL

Windows

1. Download from mysql.com
2. Run the installer
3. Follow the setup wizard
4. Set root password

macOS

# Using Homebrew
brew install mysql
brew services start mysql

Linux

# Ubuntu/Debian
sudo apt update
sudo apt install mysql-server

# Start service
sudo systemctl start mysql

Connecting to MySQL

# Command line
mysql -u root -p

# Enter password when prompted

Basic Commands

-- Show databases
SHOW DATABASES;

-- Create database
CREATE DATABASE mydb;

-- Use database
USE mydb;

-- Show tables
SHOW TABLES;

Creating First Table

-- Create users table
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    age INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Insert data
INSERT INTO users (name, email, age) VALUES
('John Doe', 'john@example.com', 25),
('Jane Smith', 'jane@example.com', 30);

-- Query data
SELECT * FROM users;

Mini Practice

Set up MySQL that:

1. Installs MySQL
2. Connects to the server
3. Creates a database
4. Creates and queries a table

Up Next

Next: Learn about MySQL Installation.