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
service httpd status
if already installed then go to the next step otherwise install the apache on VPS
yum install httpd -y
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
sudo apt install epel-release
And now install the PHPMyAdmin
sudo yum install phpmyadmin
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
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
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.