STEPS:
// Update and Upgrade Packages //
sudo apt update
sudo apt upgrade
// Setup Apache2 (You Can Use Nginx) //
sudo apt install apache2 -y
sudo systemctl enable apache2.service
sudo systemctl start apache2.service
// Install MySQL //
sudo apt-get install mariadb-server mariadb-client -y
sudo mysql_secure_installation
// Install PhpMyAdmin //
sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl -y
// Fix Root Login //
sudo mysql -u root
use mysql
update user set authentication_string=password('Password Here') where user='root';
update user set plugin='mysql_native_password' where user = 'root';
flush privileges;
exit
Now, when you access your phpMyAdmin subdirectory, you will be prompted for the additional account name and password that you just configured:
http://domain_name_or_IP/phpmyadmin
