PhpMyAdmin On VPS - LinuxHunt

PhpMyAdmin On VPS

PhpMyAdmin On VPS

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

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

Here you will see four different require ip strings matched with long IPs. The default value is 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 . 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 The file will be in the phpMyAdmin installation directory. For us it is /etc/phpMyAdmin.


Post A Comment

Get notified automatically by email when there is new content!
For Questions or Comments, Contact us: editor @

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

LinuxHunt will use the information you provide on this form to be in touch with you and to provide updates.