Tutorial
How To Install and Secure phpMyAdmin on a CentOS 6.4 VPS
Not using CentOS 6?Choose a different version or distribution.
Status: Deprecated
This article covers a version of CentOS that is no longer supported. If you are currently operating a server running CentOS 6, we highly recommend upgrading or migrating to a supported version of CentOS.
Reason: CentOS 6 reached end of life (EOL) on November 30th, 2020 and no longer receives security patches or updates. For this reason, this guide is no longer maintained.
See Instead: This guide might still be useful as a reference, but may not work on other CentOS releases. If available, we strongly recommend using a guide written for the version of CentOS you are using.
The following DigitalOcean tutorial may be of immediate interest, as it outlines installing phpMyAdmin on a CentOS 7 server:
Introduction
Many websites and applications require databases to store and manage large sets of information. MySQL and MariaDB are popular database management systems because of their flexibility, power, and ubiquity.
For many users, managing databases is difficult from the command line. For those who prefer to use a web interface, phpMyAdmin is a great alternative to command driven management.
In this guide, we will cover how to install and configure phpMyAdmin on a CentOS 6.4 VPS. The procedure should be fairly similar for other versions.
Step One — Install a LAMP Stack
Before we can install phpMyAdmin, we need to install Apache, MySQL, and PHP on our server. Together, along with the underlying operating system, this is known as a LAMP stack (Linux, Apache, MySQL, PHP).
We can go ahead and install the necessary components from the default yum repositories by typing:
- sudo yum install httpd mysql-server php php-mysql
A web server, database server, and dynamic processing language will be installed on your server and ready to use.
Step Two — Configure the LAMP Stack
Next, we need to configure the components that we have just installed.
Start the Web Server
We can start by turning on our web server. The following command will start Apache:
- sudo service httpd start
Check that the server is up and running by visiting your server’s IP address in a web browser:
http://server_IP_addr
You should see the default CentOS Apache test page. If you do not want to use a browser, you can view the raw HTML of the page with curl:
curl 127.0.0.1
The first part of the results should have text that looks like this:
Output<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<head>
<title>Apache HTTP Server Test Page powered by CentOS</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<style type="text/css">
. . .
If you can see this page, the web server is up and running.
Configure MySQL
Next, we can configure MySQL, our database. Start the service by typing:
- sudo service mysqld start
The first thing we should do is run a simple security script, which will lock down some dangerous defaults. It will also allow us to set a database password for the root administrative user:
- sudo mysql_secure_installation
The first question should ask you to enter the current password for the MySQL database. Since we haven’t configured a password yet, just hit ENTER. You can then choose and confirm a password for the database immediately. Hit ENTER through all of the remaining prompts to select the default values.
You can test that your database password was set correctly by typing:
- mysql -u root -p
You will be prompted for the database password you just issued. After typing it in, you should be dropped into a MySQL session:
-
Type exit to return to your shell session:
- exit
Your database is ready to go now.
Step Three — Install phpMyAdmin
Now, we are ready to install the phpMyAdmin package. This software is not available in the CentOS 6 default repositories. However, it is avialable in the EPEL repos (Extra Packages for Enterprise Linux).
We can add access to the EPEL repositories to our system by typing:
- sudo yum install epel-release
After accepting the new repository, you can install the phpMyAdmin package by typing:
- sudo yum install phpmyadmin
This will install phpMyAdmin. We still must configure it though.
Step Four — Configure phpMyAdmin
For security purposes, we should lock down access to the phpMyAdmin interface to a specific IP address.
Find Your IP Address
You will need to know the IP address of the computer you plan on using to access your databases. This is a security precaution so that unauthorized people cannot connect.
Note: This is the not the IP address of your VPS, it is the IP address of your home or work computer.
You can find out how the greater web sees your IP address by visiting one of these sites in your web browser:
Compare a few different sites and make sure they all give you the same value. Write this down.
Configure Apache Files
The phpMyAdmin package installs an Apache Virtual Host file that is used to configure web access. Open the file with the following command:
- sudo nano /etc/httpd/conf.d/phpMyAdmin.conf
By default, this configuration only allows access from the same computer that is hosting the software. Because the databases, web server, and administration software are hosted on a VPS instead of your home computer, we will have to adjust these values.
This is where the IP information about your home computer comes in handy. We will change every reference to 127.0.0.1 with the IP address you found.
There should be four locations that you need to change:
. . .
Require ip your_workstation_IP_address
. . .
Allow from your_workstation_IP_address
. . .
Require ip your_workstation_IP_address
. . .
Allow from your_workstation_IP_address
. . .
Save and close the file.
You need to restart the server with the following command:
- sudo service httpd restart
Step Five — See the Results!
Your interface should now be configured and ready to access.
Point your web browser to your VPS IP address followed by “/phpmyadmin”
http://VPS_IP_address/phpmyadmin
You will be asked to log in. Use the user root and the password that you selected during the MySQL configuration stage.
<img src=“https://assets.digitalocean.com/articles/cent_phpmyadmin/login.png” alt=“phpMyAdmin login prompt” />
After you provide the requested credentials, you will have access to the phpMyAdmin interface:
<img src=“https://assets.digitalocean.com/articles/cent_phpmyadmin/main_screen.png” alt=“phpMyAdmin main interface screen” />
Congratulations, you can now begin managing your database software from the web interface!
<div class=“author”>By Justin Ellingwood</div>
Thanks for learning with the DigitalOcean Community. Check out our offerings for compute, storage, networking, and managed databases.
author
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.
I have dynamic ip at home, is it a matter after my ip was schanged?
Moderator - is there a way for me to delete my duplicate posts?
For Centos 5.9 - you can use wget http://download.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
@Blick: Yes, it would stop working since it’s locked down to your IP address at a specific point in time so if it changes it doesn’t get automatically updated on your droplet.
@raiello: I’ve deleted the duplicate posts. :]
I just install phpmyadmin but i can’t access it mozilla always say
Forbidden
You don’t have permission to access /phpmyadmin on this server.
Apache/2.2.15 (CentOS) Server at 162.243.141.52 Port 80
what should i do?
@carl.victor: Have you followed the <strong>Configure Apache Files</strong> section properly and entered your IP address there?
What do you suggest for those of us without a static ip address at home? My ISP changes my ip address daily (which is a serious PITA) so I also receive a 403 as I am unable to complete the last section.
I repeated this locally, installed a VM of CentOS minimal, etc etc. Going through the phpmyadmin config doc I see that unless SSL is used that the required ip should specifically be set.
So would a self signed SSL cert take care of this?
Thanks.
On yet another thought… probably best thing to do is change the ip when it is needed… it is not so often that phpmyadmin access is needed.
Problem solved :-)
How about for an nginx server, I have no desire to back to apache?