Install ubuntu server then insall mysql phpmyadmin then try few databases from linux side and webportal using queries, Install Webmin.
Follow below instructions
Update your package list: sudo apt update
Upgrade installed packages: sudo apt upgrade -y
lsb_release -a
cat /etc/os-release
hostnamectl
sudo apt update && sudo apt upgrade -y - install the latest software patches
sudo reboot
Install package: sudo apt install mysql-server
Verify status: Check if the service is running with sudo systemctl status mysql
Access MySQL: sudo mysql.
Set root password: Replace 'your_password' with a strong one
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '6300';
EXIT;
PHPMYAdmin
Run the following commands to update your local package index and install the necessary files:
sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl
ifconfig: An older, deprecated tool. If it is not found, you can install it via sudo apt install net-tools
sudo mysql -u root -p SHOW DATABASES;
Type the following command in the text field: CREATE DATABASE my_database_name;
http://192.168.5.152/phpmyadmin
Choose whether you want backup in server or wanna download in your computer through browser
Now Lets restore databases
another powerful Webserver and mostly widely used then acpache is nginx, let install nginx and install it's aapanel for GUI (web Interface)