PhpMyAdmin is a popular web interface for web developers to manage MySQL databases. This tutorial will guide you through on how to install and secure PhpMyAdmin on your CentOS web server.
This guide assumes that you already have Apache and MySQL installed on your CentOS web server.
(Optional) Note that if you want to access PhpMyAdmin using SSL, then you will need to configure SSL certificate by referring to the following guide.
Setting up an SSL Secured Web Server with CentOS
1. Add EPEL Repositories
PhpMyAdmin is not included in CentOS packages, therefore you will need to add EPEL (Extra Packages for Enterprise Linux) to your web server.
cd ~ wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
(Optional) Run the following command to install wget if you haven’t install wget yet
sudo yum install wget
Command to install EPEL packages to your web server
sudo rpm -ivh epel-release*
Check that EPEL has been added to your repository
You should see the following
repo id repo name status base CentOS-6 - Base 6575 epel Extra Packages for Enterprise Linux 6 - x86_64 11746 extras CentOS-6 - Extras 38 updates CentOS-6 - Updates 159
Once done remove the respository configuration package
2. Download PhpMyAdmin
Command to download PhpMyAdmin
sudo yum install phpmyadmin
3. Configure PhpMyAdmin
Find your IP Address first
Then edit PhpMyAdmin config file
sudo nano /etc/httpd/conf.d/phpMyAdmin.conf
Modify the following 4 lines in the config file
. . . Require ip your_workstation_IP_address . . . Allow from your_workstation_IP_address . . . Require ip your_workstation_IP_address . . . Allow from your_workstation_IP_address . . .
Then save and close the config file
4. Open PhpMyAdmin in your Web Browser
Open the following url in your web browser
That’s it you are done!
Feel free to contact me at [email protected] if you have any questions.