Install PhpMyAdmin, Apache2 and MySQL on a VPS (Ubuntu/Debian) ​
Install Apache2: ​
open a terminal window on your server
enter the following command to start the installation of Apache2:
sudo apt update && apt install apache2 -y
sudo apt update && apt install apache2 -y
Install MySQL: ​
enter the following command to start the installation of MySQL:
sudo apt install mysql-server -y
sudo apt install mysql-server -y
during the installation you will be asked to set a password for the MySQL root user. Enter a secure password and save it in a safe place.
Install PhpMyAdmin: ​
enter the following command to start the installation of PhpMyAdmin:
sudo apt install phpmyadmin -y
sudo apt install phpmyadmin -y
during the installation you will be asked to select a web server. Select Apache2 and press the Enter key
during the installation you will be asked to set a password for the PhpMyAdmin administrator account. Enter a secure password and save it in a safe place
when you are finished, open your web browser and enter the address "http://Server-Adresse/phpmyadmin/". You should be prompted to log in with your PhpMyAdmin administrator account.
Configure PhpMyAdmin: ​
open the file "config.inc.php", which is located in the directory "/etc/phpmyadmin/"
nano /etc/phpmyadmin/config.inc.php
nano /etc/phpmyadmin/config.inc.php
change the line "$cfg['blowfish_secret']" to a random string that is at least 32 characters long. c. Save the changes and close the file.
INFO
Now save the input with CTRL + O and close the window with CTRL + X