Web server management
Apache setup & Virtual servers
Initial setup Install packages sudo apt install apache2 mariadb-server libapache2-mod-php php-my...
SQL
After install ensure secure access sudo mysql_secure_installation Logging in mysql -u USER...
SSL & Certificate management
Install certbot and run setup sudo apt install certbot python3-certbot-apache a2enmod ssl sudo...
PostgreSQL
Install Install postgresql and postgis for coordinates data sudo apt install postgresql postgis...
SQL Reference
Create a table that auto deletes on other table deletion CREATE TABLE tradie_postcode_covered ( ...
Mail Server
Initial setup 1 - Updates sudo apt update && sudo apt upgrade -y 2 - Install docker and do...