Install MySQL & Phpmyadmin

Apache2

Update Server System :

sudo apt update
sudo apt upgrade -y

Install Apache2 service :

sudo apt install apache2 -y

MySQL

Install MariaDB Server :

sudo apt install mariadb-server -y

Start the MariaDB Server setup :

mysql_secure_installation

You will get an output as shown in the screenshot. Here you have to press Enter :

Change root password. Confirm with N

Block anonymous login. Confirm with Y

Disable public root access. Confirm with Y

Remove the test database. Confirm with Y

Reload user rights. Confirm with Y

The MariaDB server is now fully configured and secured 🎉

Phpmyadmin

Install Phpmyadmin with Full Extensions :

sudo apt install php-mbstring php-zip php-gd phpmyadmin php8.2 php-json php-curl -y

• For the server selection choose apache2, click space and click enter

Create "admin" User in MySQL Server :

CREATE USER 'adminuser'@'%' IDENTIFIED BY 'adminpassword';
GRANT ALL PRIVILEGES ON *.* TO 'adminuser'@'%';
FLUSH PRIVILEGES;
quit

Now, open your phpmyadmin page http://your_server_ip/phpmyadmin and login 🎉