phpMyAdmin is an open source tool for managing database servers like MySQL, MariaDB and Drizzle.

Use of Tool?

manage databases, tables, relations, users, permission, etc.
Display multiple information set through stored procedure or queries,
Directly create, update, and delete, tables or databases
Get a backup and restore the databases (Import and Export Databases)
create, edit, export and drop events and triggers
administer multiple servers
Database export to different format  like CSV, XML, PDF, ISO/IEC 26300, Microsoft Word, and LATEX.

How to Install:

Need to install Apache and MySQL servers,
 

# yum -y  install httpd

# yum -y install mysql mysql-server

remi repository will help you to install phpMyAdmin latest version,

RHEL 7:
# http://rpms.famillecollet.com/enterprise/remi-release-7.rpm

RHEL 6/CentOS:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

RHEL 5/CentOS:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

Install RPM Package:



rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm



Retrieving http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

warning: /var/tmp/rpm-tmp.BTOfEl: Header V3 DSA/SHA1 Signature, key ID 00f97f56: NOKEY

Preparing...                ########################################### [100%]

   1:remi-release           ########################################### [100%]

Install phpMyAdmin:



yum --enablerepo=remi install phpMyAdmin -y



Dependencies Resolved

====================================================================================

Package          Arch           Version               Repository              Size

Updating:        

phpMyAdmin      noarch            4.2.5-1.el6.remi     remi                   4.7 M



Installing for dependencies:

compat-mysql51  x86_64            5.1.54-1.el6.remi     remi                  1.4 M



====================================================================================

Configuration Path:
 
/etc/phpMyAdmin/config.inc.php

/etc/httpd/conf/phpmyadmin.conf

Start your Apache and MySQL Server,
 
# /etc/init.d/httpd start

# /etc/init.d/mysql start

Create MySQL User:


Mysql> CREATE USER 'linuxuser'@'localhost' IDENTIFIED BY 'userpassword';

Do you want to change root password for mysql:


mysql> SET PASSWORD FOR root@localhost = PASSWORD('mysqlrootpass');

Query OK, 0 rows affected (0.00 sec)


Access phpMyAdmin on Browser.

Once installation has been completed access the tool on browser bye the URL: http://your-system-ip/phpMyAdmin/

Login: Use MySQL user and password.

phpMyAdmin Home Page:



If you could not get latest version by yum installation, download that packages and install from below URL :
 
http://www.phpmyadmin.net/home_page/downloads.php