Install PHPMyAdmin on CentOS (Apache)

If you are running CentOS on your server and want to install PHPMyAdmin, this tutorial is for you.


You should have installed MySQL on your server.

Apart from this, we need to install the EPEL for Centos Repositories. Use this command to get the repositories:

rpm -ivh

After this, update the repositories with this command:

yum check-update

With this done, we are now ready to install PHPMyAdmin


i) Install PHPMyAdmin. Use the command below

sudo yum install phpmyadmin

ii) Configure PHP with Apache

Open the conf file located at /etc/httpd/conf.d/phpMyAdmin.conf

Edit the file with a Text editor such as Notepad and edit the following lines:

Require IP

Allow From


Require IP [insert your IP]

Allow from [insert your IP]

Note: You can find out your IP at this website:

The IP you are supposed to insert the above lines are your internet IP, not your VPS IP.

Also, there are two instances of Require IP and Allow From on the file. Make sure you replace the default in both instances with your Internet IP (IP of the computer that you will be using the access PHPMyAdmin)

iii) Save the file

iv) Restart Apache service using this command

sudo service httpd restart

And with that, PHPMyAdmin will have been installed on your server.

Accessing PHPMyAdmin

To access your PHPMyAdmin, simply go to http://[enter your VPS server IP/phpmyadmin e.g.

if you server IP is 189.890.0.8, you will go to http://189.890.0.8/phpmyadmin

To log into the PHPMyAdmin, use your root username and password.

If you are using another OS apart from CentOS, you can enter root for the username and leave the password blank.

If you have forgotten your mysql username and password, use the command below to reset it

$ mysqladmin -u root password NEWPASSWORD

Note: replace NEWPASSWORD with your intended password.

That’s it, folks. If you have any questions, let me know in the comments below.

You can also buy me some coffee if I solved your issue:

Install PHPMyAdmin on CentOS (Apache) 1

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Get more tech stuff like this
in your inbox

Subscribe to our mailing list for occasional amazing tech stuff.

Thank you for subscribing.

Something went wrong.