PhpMyAdmin On VPS

Asterisk On Linux
February 19, 2020
syllabus O-level
March 2, 2020
Show all

PhpMyAdmin On VPS

Worker with pipe wrench. Isolated over white background

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.

Leave a Reply

Your email address will not be published. Required fields are marked *