SQL Installation & Setup – MySQL, PostgreSQL & SQLite

import sqlite3

# Creates learning.db if it doesn't exist
conn = sqlite3.connect("learning.db")
cursor = conn.cursor()

cursor.execute("""
    CREATE TABLE IF NOT EXISTS employees (
        id         INTEGER PRIMARY KEY AUTOINCREMENT,
        first_name TEXT NOT NULL,
        salary     REAL
    )
""")

cursor.execute("INSERT INTO employees (first_name, salary) VALUES ('Alice', 85000)")
conn.commit()

for row in cursor.execute("SELECT * FROM employees"):
    print(row)

conn.close()

# macOS (already installed) or Linux
sqlite3 learning.db

# Windows: download sqlite-tools from sqlite.org/download.html
# Unzip and run sqlite3.exe

# Inside the SQLite shell:
sqlite> CREATE TABLE test (id INTEGER PRIMARY KEY, name TEXT);
sqlite> INSERT INTO test VALUES (1, 'Hello SQL');
sqlite> SELECT * FROM test;
sqlite> .quit

# Install MySQL
brew install mysql

# Start the MySQL service
brew services start mysql

# Connect (no password on fresh install)
mysql -u root

# Set a root password (recommended)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_password';
FLUSH PRIVILEGES;

# Install MySQL server
sudo apt update
sudo apt install mysql-server

# Start the service
sudo systemctl start mysql
sudo systemctl enable mysql   # auto-start on boot

# Run the security setup wizard (sets root password, removes test DB)
sudo mysql_secure_installation

# Connect
mysql -u root -p

# Download MySQL Installer from dev.mysql.com/downloads/installer/
# Run the installer, choose "Developer Default" setup type
# Follow the wizard — it installs MySQL Server + MySQL Workbench + Shell

# After installation, connect via Command Prompt:
mysql -u root -p

# Install PostgreSQL 16
brew install postgresql@16

# Add to PATH (add this to ~/.zshrc or ~/.bash_profile)
export PATH="/opt/homebrew/opt/postgresql@16/bin:$PATH"

# Start the service
brew services start postgresql@16

# Connect to the default postgres database
psql -U postgres

# Or create a database for learning
createdb learning_sql
psql learning_sql

# Install PostgreSQL
sudo apt update
sudo apt install postgresql postgresql-contrib

# Start the service
sudo systemctl start postgresql
sudo systemctl enable postgresql

# Connect as the postgres superuser
sudo -u postgres psql

# Inside psql — create a database
CREATE DATABASE learning_sql;
\c learning_sql   -- connect to it
\l                -- list all databases
\dt               -- list tables in current DB
\q                -- quit