PhpMyAdmin is an open source tool used for the administration of MySQL.
PhpMyAdmin provides the GUI(graphical user interface) for the ease to create , edit, delted, manage users and databases. It is also used to give permission, upload and extract the contents of databases and much more tasks.
You must have LAMP already installed in your cent os machine. You can follow the link given below to install LAMP.
http://kb.cloudatcost.com/wp-admin/post.php?post=1304&action=edit
Finally install PhpMyAdmin
Execute the command given below:
rpm –import http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt
yum install http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
yum -y install phpmyadmin
To allow remote login to the PhpMyAdmin
vi /etc/httpd/conf.d/phpMyAdmin.conf
Replace text “Allow from 127.0.0.1” to “Allow from all”, save the file and exit. line number 25
To configure PhpMyAdmin
Edit the configuration file
vi /etc/phpMyAdmin/config.inc.php
Replace text:
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
To
$cfg[‘Servers’][$i][‘auth_type’] = ‘http’;
which is the Authentication method based on cookie or http.
Once done save and exit.
Restart the apache
service httpd restart
You can verify whether or not it has been successfully installed by browsing your ip address:
http://your-ip-address/phpmyadmin
it will ask for username and password which will be root and password of you mysql which we have learnt in previous article.
