VanillaCoffeeSoft

VanillaCoffeeSoft

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