How to install phpMyAdmin on VPS Hosting Server
Here I have show you step by step guide, which you follow to install phpMyAdmin on VPS hosting server.
Step 1: Log on to VPS
First, log on to your VPS.
Step 2: Install phpMyAdmin
I Recommend you to use the yum system to install software. Type the given commands:
yum install phpmyadmin
After successful installation, the “phpMyAdmin.conf” file will appear in “httpd/etc/httpd/conf.d”. before editing save it by the following command:
“cp /etc/httpd/conf.d/phpMyAdmin.conf /etc/httpd/conf.d/phpMyAdmin.conf.orig”
then edit this file and make some necessory changes.
vi /etc/httpd/conf.d/phpMyAdmin.conf
By default, it denies access for all sources except localhost 127.0.0.1.
To allow access, make the following changes:
<Directory /usr/share/phpMyAdmin/>
AddDefaultCharset UTF-8
<IfModule mod_authz_core.c>
# Apache 2.4
<RequireAny>
#R
Require all granted
</RequireAny>
<Directory /usr/share/phpMyAdmin/setup/>
<IfModule mod_authz_core.c>
# Apache 2.4
<RequireAny>
#Require ip 127.0.0.1
#Require ip ::1
Require all granted
</RequireAny>
</IfModule>
Now restart Apache using the following command:
systemctl restart httpd
Step 3: Test phpMyAdmin
Visit “http://your_VPS_IP/phpmyadmin” in your browser. It should display the following picture:
If this image appears then its mean phpMyAdmin is installed correctly. Else you have made some mistake or something else is required. For server solution or web hosting visit cpanel.com. Read how to install CentOS web panel on VPS.