sudo aptitude install mariadb-server mariadb-client
sudo systemctl status mysql
sudo mysql_secure_installation

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

sudo /etc/init.d/mysql restart

sudo mysql -u root -p

CREATE USER 'me'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'me'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT

sudo nano /etc/mysql/my.cnf

[mysqld]
skip-networking=0
skip-bind-address

sudo /etc/init.d/mysql restart

sudo aptitude install nginx
sudo systemctl status nginx

sudo openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/ssl/private/nginx-selfsigned.key -out /etc/ssl/certs/nginx-selfsigned.crt

sudo aptitude install letsencrypt

sudo mkdir -p /var/www/letsencrypt
sudo nano /etc/nginx/sites-available/default

server {
	listen 80 default_server;
	listen [::]:80 default_server;

	server_name _;

	location ~ /\.well-known/acme-challenge/ {
		allow all;
		root /var/www/letsencrypt;
		try_files $uri =404;
	}

	location / {
		return 301 https://$host$request_uri;
	}
}

server {
	# listen 80 default_server;
	# listen [::]:80 default_server;

	listen 443 ssl http2 default_server;
	listen [::]:443 ssl http2 default_server;
	
	ssl_certificate /etc/ssl/certs/nginx-selfsigned.crt;
	ssl_certificate_key /etc/ssl/private/nginx-selfsigned.key;

	root /var/www/html;

	# Add index.php to the list if you are using PHP
	index index.html index.htm index.nginx-debian.html;

	server_name _;

	location / {
		# First attempt to serve request as file, then
		# as directory, then fall back to displaying a 404.
		try_files $uri $uri/ =404;
	}

	# pass PHP scripts to FastCGI server
	#location ~ \.php$ {
	#	include snippets/fastcgi-php.conf;
	#
	#	# With php-fpm (or other unix sockets):
	#	fastcgi_pass unix:/var/run/php/php7.2-fpm.sock;
	#}

	# deny access to .htaccess files, if Apache's document root
	# concurs with nginx's one
	#
	#location ~ /\.ht {
	#	deny all;
	#}
}

sudo nginx -t
sudo service nginx reload

sudo letsencrypt certonly -a webroot --webroot-path=/var/www/letsencrypt -m [email protected] --agree-tos -d example.com

sudo mkdir -p /var/www/example.com
sudo nano /etc/nginx/sites-available/default

server {
	listen 443 ssl http2;
	listen [::]:443 ssl http2;

	root /var/www/example.com;
	
	ssl_certificate     /etc/letsencrypt/live/example.com/fullchain.pem;
	ssl_certificate_key /etc/letsencrypt/live/example.com/privkey.pem;

	index index.html;
	
	server_name example.com;
	
	location / {
		try_files $uri $uri/ =404;
	}
}

sudo nginx -t
sudo service nginx reload

sudo nano /etc/letsencrypt/renewal-hooks/post/reload-services.sh

#!/bin/sh
service nginx reload

sudo chmod 750 /etc/letsencrypt/renewal-hooks/post/reload-services.sh

sudo aptitude install php-fpm php-common php-mysql php-gd php-cli
sudo systemctl status php7.4-fpm
sudo nano /etc/nginx/sites-available/default

	index index.html index.htm index.nginx-debian.html index.php;

	location ~ \.php$ {
		include snippets/fastcgi-php.conf;
		fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;
	}

sudo nginx -t
sudo service nginx reload

echo "<?php phpinfo(); ?>" | sudo tee /var/www/html/info.php

sudo aptitude install phpmyadmin

sudo ln -s  /usr/share/phpmyadmin /var/www/html/phpmyadmin

sudo mysql -u root

CREATE USER 'user123'@localhost IDENTIFIED BY 'password123';
GRANT ALL PRIVILEGES ON *.* TO 'user123'@localhost;
GRANT GRANT OPTION ON *.* TO 'user123'@localhost;
FLUSH PRIVILEGES;

sudo apt install bindfs
mkdir www
sudo nano /etc/fstab

bindfs#/var/www /home/user123/www fuse force-user=user123,force-group=user123,create-for-user=www-data,create-for-group=www-data,chgrp-ignore,chown-ignore,x-systemd.requires=/home,nofail 0 0