Most of the users are recommended php_my_admin for connecting with the database. Because php_my_admin is user-friendly and its GUI is better than MySQL. In this Developers get more options instead of command typing. So maximum developers demanding for php_my_admin. IN the case of Cpanel hosting we can get easy access (have PHPMyAdmin option) but in another case of the VPS server, we have to install it separately.

So I sharing the commands for installing the PHPMyAdmin on the VPS server. You have to just copy these commands and paste it on Linux terminal.

!. check that on VPS the apache is installed or not
systemctl status httpd

or

service httpd status

if already installed then go to the next step otherwise install the apache on VPS
yum install httpd -y
or
sudo apt install httpd -y

To get started, we will install phpMyAdmin from the default Ubuntu repositories.

sudo apt update
sudo apt install phpmyadmin php-mbstring php-gettext


Now install dependency for PHPMyAdmin
sudo yum install epel-release
or
sudo apt install epel-release

And now install the PHPMyAdmin

sudo yum install phpmyadmin
or
sudo apt install phpmyadmin


note: the PHPMyAdmin is installed on your VPS but still you cant access it from your network you have to make changes inside the conf file of it.
go to this path ” /etc/httpd/conf.d/  ” or edit this file “phpMyAdmin.conf ” also you can type this

vim /etc/httpd/conf.d/phpMyAdmin.conf

Here you will see four different require ip strings matched with long IPs. The default value is 127.0.0.1. Replace that value with the IP of the machine you will be using to access phpMyAdmin. You can use a tool like WhatsMyIP to check your IP. Save and exit the file by hitting escape and typing in :wq.

you can also change it 0.0.0.0/24 . or your own ip
Restart the Apache Web Server
systemctl restart httpd

Check if phpMyAdmin is Working
your_ip/phpmyadmin

Locate Your phpMyAdmin Username and Password
Your username and password will be located in the file config.inc.php. The file will be in the phpMyAdmin installation directory. For us it is /etc/phpMyAdmin.