Install phpMyAdmin

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Install epel for easy installation.

rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

Installation

yum -y install phpmyadmin

Configuration
Edit /etc/httpd/conf.d/phpMyAdmin.conf and modify the Require ip and Allow from

vi /etc/httpd/conf.d/phpMyAdmin.conf

Require ip 192.168
Allow from 192.168

This will allow any client with a 192.168.x.x address to connect.

restart Apache

service httpd restart

Connect to web Service

http://ip_address_of_server/phpMyadmin

The username and password is that of your MySQL root username/password.