Instructions for installing PhpMyAdmin, Apache2 and MySQL on a Linux VPS.
Install Apache2
-
Update packages
Open a terminal window on your server and run the following command:sudo apt update && apt install apache2 -y
Install MySQL
-
Install MySQL
Enter the following command to start the installation of MySQL:sudo apt install mysql-server -y -
Set password
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
-
Install PhpMyAdmin
Enter the following command to start the installation of PhpMyAdmin:sudo apt install phpmyadmin -y -
Select web server
During the installation you will be asked to select a web server. Select Apache2 and press the Enter key. -
Set admin password
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. -
Test installation
When you are finished, open your web browser and enter the addresshttp://<server-ip>/phpmyadmin/. You should be prompted to log in with your PhpMyAdmin administrator account.
Configure PhpMyAdmin
-
Open configuration
Open the fileconfig.inc.php, which is located in the directory/etc/phpmyadmin/:nano /etc/phpmyadmin/config.inc.php -
Change Blowfish Secret
Change the line$cfg['blowfish_secret']to a random string that is at least 32 characters long.