PhpMyAdmin installations and security on CentOS

In this article I will teach people how to install phpMyAdmin 2 on CentOS.

I. Install phpMyAdmin package

Before you proceed to install phpMyAdmin you need to install before LAMP or LEMP server on CentOS.

1. Add EPEL repo

phpMyAdmin is not available in the default repo of CentOS. Therefore, if you should want to install, you need to use Fedora Projects EPEL (Extra Packages for Enterprise Linux) repo.

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

Install

rpm -ivh epel-release*

Check back repo by

yum repolist

. . .

repo id         repo name                                       status

base            CentOS-6 - Base                                 6381

epel            Extra Packages for Enterprise Linux 6 - x86_64  9788

extras          CentOS-6 - Extras                                 13

updates         CentOS-6 - Updates                              1336

repolist: 17518

You will see  EPEL, it have in the list repo.

Now you delete the repo file previously downloaded

rm epel-release*

2. Install phpMyAdmin

rm epel-release*

3. Config phpMyAdmin

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

To be able to have access to phpMyAdmin you need to change the IP information from 127.0.0.1 to All.

You can also restrict access by using your IP. However, Due to the characteristics ADSL network VN frequently changing IP so you should not use personal IP.

There are 4 places you need to change IP

. . .

Require ip All

. . .

Allow from All

. . .

Require ip All

. . .

Allow from All

. . .

Save and restart the server

service httpd restart

Check your results by accessing http: // <youraddress> / phpmyadmin then login using account root mysql.

II. PhpMyAdmin Install script

With the above steps you may have installed phpMyAdmin. However, there are a number of reasons, so I encourage you to using phpMyAdmin scripts.

Only when the new run using the memory -> server saves resources

Customizable path phpmyadmin -> more security

First you need to choose the version you want to install the phpMyAdmin homepage

Copy the link directly to with the file extension is .zip. 

Example 4.2.6 version is http://jaist.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.2.6/phpMyAdmin-4.2.6-english.zip

In directory www . It have contains content sites, run the following command

wget http://jaist.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.2.6/phpMyAdmin-4.2.6-english.zip

Extract

unzip phpMyAdmin-*.zip

Installation is complete you will have a folder phpMyAdmin-4.2.6-english, to use your access to the link http: // <youraddress> /phpMyAdmin-4.2.6-english. Of course you can rename anything you want to use and more secure.