MySQL

MySQL is used as main database source in this solution. You should have it installed on your VPS using following commands:

1
2
3
4
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm
sudo yum install mysql-server
sudo systemctl start mysqld
1
2
sudo apt-get update
sudo apt-get install mysql-server

And Then

After you have installed MySQL you can do mysql installation wizard to make it more secure and set a password for your database. Doing this is important because without this your users info could be open for security risks. Enter following command and wizard will be started:

1
mysql_secure_installation

Tip

If this installation requested password that you didn't set during installation you should use this command to get a temporary password to be able to continue installation:

1
sudo grep 'temporary password' /var/log/mysqld.log