Installation & 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.
Download the rpm of epel repo.
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.
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:
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:
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!