Server setup guide

Introduction

This is my personal guide to setup an Ubuntu server. To build this guide I've used the knowledge available on the internet and the sources are, as much as possible, linked on this guide.

I will be updating this guide as my knowledge and experience evolves. I will be glad to take advice, suggestions and/or pull requests.

Table of Contents

1. Initial Setup
   1. Deploy the server
   2. System update
   3. Create a non root user
   4. Setup SSH key-based login
   5. Test the user SSH keys login and secure it
   6. Setup the firewall
   7. Git
   8. Bash prompt customization
   9. Additional folders in the home folder
2. Software installation
   1. Apache Server installation
      1. Install Apache
      2. Setup the firewall
      3. Check the Apache Server
      4. Change the Apache Server web root folder
      5. Setup the default directory to be served by Apache Web Server
      6. Set permissions for the Apache Server root folder
      7. Keep the Apache Server root folder access permissions consistent with a cron job
   2. MySQL Server installation
      1. Install MySQL
      2. Configure MySQL
      3. Move MySQL data folder
   3. PHP installation
      1. Install PHP
      2. Install PHP extensions
      3. Install FastCGI Process Manager (FPM)
      4. PHP configuration improvements
   4. Docker installation
      1. Install Docker
   5. linkding installation
      1. Install linkding
      2. Reverse Proxy Setup
      3. Create and set an SSL Certificate
   6. traggo installation
      1. Install traggo
      2. Reverse Proxy Setup
      3. Create and set an SSL Certificate
3. Server Management
   1. Apache Server Management
      1. Apache | Create a Virtual Host
      2. Apache | Secure Apache with Let's Encrypt
   2. MySQL Server Management
      1. MySQL | Create a MySQL database
      2. MySQL | Create a MySQL user
      3. MySQL | Grant privileges to a MySQL user
      4. MySQL | Import a database from a file to a MySQL database
4. Linux Upskill Challenge | Resources & Extensions
   1. Day 1 | Get to know your server