I used MSSQL for a long time but it can be a bit bloated especially when using on a CPU and Memory limited environment.
And no, I will not use postgres. Don’t care how “Good” it is.
you will need wget
Start by downloading the MySql repository.
This stupid link always changes make sure you have the latest
sudo wget https://dev.mysql.com/get/mysql-apt-config_0.8.26-1_all.deb
Install whatever you downloaded
sudo apt install ./mysql-apt-config_*_all.deb
For any modifications run this:
sudo dpkg-reconfigure mysql-apt-config
Ok… now for the actual installation run this
sudo apt update
sudo apt install mysql-server
sudo systemctl enable mysql
To harden the installation run this
sudo mysql_secure_installation
Now try logging in as root and test out some SQL commands setup should be done
mysql -u root -p
Accessing the database from an outside network is a whole other story