Saturday, April 11, 2026

Install Ubuntu Server with Mysql, PHP myadmin and Webmin

 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