Wednesday, May 23, 2012

Install phpMyAdmin on CentOS 5 - With Yum Installation

Install MySQL

yum install mysql-server mysql mysql-devel
chkconfig mysqld on
service mysqld start
 Set Password for MYSQL
mysql -u root -p
enter password

Install PHP & HTTPD

yum install php php-mysql
yum Install httpd

Download the rpmforge package from Centos website
after installing rpmforge run following command
yum install phpmyadmin

vi /etc/httpd/conf.d/phpmyadmin.conf
the format should be like below (allow from all)
<Directory "/usr/share/phpmyadmin">
  Order Deny,Allow
  Deny from all
  Allow from all
</Directory>


Go to phpmyadmin direcotry (in my case it /usr/share/phpmyadmin)
cp config.sample.inc.php config.inc.php
vi config.inc.php

Edit th config.inc.php file, find the line that contacin "blowfish_secret", and modify like below
$cfg['blowfish_secret'] = 'TypeAnything_for_secure';

(Type any secure password instead of TypeAnything_for_secure)

service httpd restart


Open browser & type http://ipaddress_of_machine/phpmyadmin
login with root
password of mysql (which you set earlier)

No comments:

Post a Comment