WordPress + MySQL VPS Setup with Docker

# via SSH to the server connect ssh root@YOUR SERVER_IP_ADDRESS # Update the system apt update && apt upgrade -y # Create new user (deploy named) adduser deploy usermod -aG sudo deploy # Switch to new user do it su - deploy

# Required packages install sudo apt install -y ca-certificates curl gnupg # GPG key add sudo install -m 0755 -d /etc/apt/keyrings curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg --dearmor -o /etc/apt/keyrings/docker.gpg sudo chmod a+r /etc/apt/keyrings/docker.gpg # Docker repo add echo "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.gpg] https://download.docker.com/linux/ubuntu $(. /etc/os-release && echo \"$VERSION_CODENAME\") stable" | sudo tee /etc/apt/sources.list.d/docker.list > /dev/null # Install Docker sudo apt update sudo apt install -y docker-ce docker-ce-cli containerd.io docker-compose-plugin # Add your user to the docker group add (for docker command without using sudo) sudo usermod -aG docker $USER newgrp docker

sudo mkdir -p /opt/wordpress sudo chown -R $USER:$USER /opt/wordpress cd /opt/wordpress

services: db: image: mysql:8.0 restart: always environment: MYSQL_DATABASE: wordpress MYSQL_USER: wp_user MYSQL_PASSWORD: StrongOnePassword123! MYSQL_ROOT_PASSWORD: CokGucluRootSifresi123! volumes: - db_data:/var/lib/mysql wordpress: image: wordpress:php8.2-apache restart: always depends_on: - db ports: - "127.0.0.1:8080:80" # out We do not open it directly, we will use Nginx environment: WORDPRESS_DB_HOST: db:3306 WORDPRESS_DB_USER: wp_user WORDPRESS_DB_PASSWORD: StrongOnePassword123! WORDPRESS_DB_NAME: wordpress volumes: - wp_data:/var/www/html volumes: db_data: wp_data:

docker compose up -d docker compose ps

# Nginx installation sudo apt install -y nginx # Configuration file create sudo nano /etc/nginx/sites-available/wordpress

server { listen 80; server_name siteadresiz.com www.siteadresiniz.com; location / { proxy_pass http://127.0.0.1:8080; proxy_set_header Host $host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; } }

# Symbolic link create sudo ln -s /etc/nginx/sites-available/wordpress /etc/nginx/sites-enabled/ sudo nginx -t sudo systemctl reload nginx # Certbot and SSL installation sudo apt install -y certbot python3-certbot-nginx sudo certbot --nginx -d siteadresiz.com -d www.siteadresiniz.com