Install phpMyAdmin
From KlavoWiki
Jump to navigationJump to search
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/7/x86_64/e/epel-release-7-7.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.