phpmyadmin with apache on centosInstallation & Configuration Tutorial – phpMyAdmin (Apache/CentOS)

Web server is necessary for phpMyAdmin to work as it is a web based tool. It provides a GUI which provides the users a very easy and efficient interface to administer the MySQL databases. With the help of phpMyAdmin, a normal person who doesn’t know the MySQL commands can work on the databases easily.

In this tutorial we will discuss how phpMyAdmin is installed in a CentOS (6) based VPS or a dedicated server. And as an additional note, control panels like cPanel, Plesk etc. installs phpMyAdmin by default and you don’t need to bother about installing it again.

MySQL server needs to be installed in the first place as it is the real database management system. This tutorial is in assumption that MySQL server is already installed. If you haven’t installed MySQL server yet, you can take a look into our tutorial on how to install MySQL server in a CentOS server

Configure EPEL repository

You can install phpMyAdmin simply via yum but you need EPEL repository for the package.4
Change the installation directory.

cd /usr/local/src/

Download the rpm of epel repo.

wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

Here I’m downloading the 64 bit rpm of epel repo but it also work with the 32 bit architecture.

Install the downloaded rpm.

sudo rpm -ivh epel-release*

Installing rpm of the epel repo configures the repository automatically.

If you check out yum repos list, you can see the EPEL repository in the list.

pma6

Install phpMyAdmin

You can install phpMyAdmin really easy with yum.

sudo yum install phpmyadmin

Configure phpMyAdmin with Apache

By default the configuration of phpMyAdmin with Apache can be done by editing the file:

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

Open the said file with any text editor tool and edit the following fields as shown below.

Require ip Server_IP_Address

Allow from Server_IP_Address

Here is a screenshot you can look into:

pma7

Restart Apache after these settings are made. To restart Apache, run this command as root.

service httpd restart

How to access phpMyAdmin panel?

You’ll be able to access phpMyAdmin by going to the URL: http://Server_IP_or_Host_Name/phpmyadmin

This will prompt the phpMyAdmin admin login credentials and you can enter the MySQL root username or any other MySQL user and its password.

That’s it – you’re all done!

Leave a Reply

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