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
Webmin Install and Setup : go to webmin site and follow script and commands
use this file to allow permission on ip
sudo nano /etc/webmin/miniserv.conf
Backup database and restore from Webmin
OR You can also backup by clicking on databse then select all
Choose whether you want backup in server or wanna download in your computer through browser
Now Lets restore databases
Let's restore from remote computer that was download through browser
Download Free Template extract and past in /var/www/html and check demo website
another powerful Webserver and mostly widely used then acpache is nginx, let install nginx and install it's aapanel for GUI (web Interface)
You can install nginx using commands
sudo apt install nginx -y
Allow both HTTP and HTTPS: sudo ufw allow 'Nginx Full'
Stop: sudo systemctl stop nginx
Start: sudo systemctl start nginx
Restart: sudo systemctl restart nginx
Reload (apply changes without downtime): sudo systemctl reload nginx
Enable (start on boot): sudo systemctl enable nginx
Install aapanel for nginx web interafce using command below or search in google
wget -O install.sh https://www.aapanel.com/script/install_7.0_en.sh && sudo bash install.sh
Once aapanel installed you need to reset ID/Password using command sudo bt then number 5 and 6 for new user/password.
go to web browser enter server ip:port and enter user/password