PhpMyAdmin in centos
Install PhpMyadmin: yum search phpMyAdmin ; if there is no showing phpMyAdmin packet we must install epel.
- rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-3.noarch.rpm
- after installation visit to : http://192.168.2.125/phpMyAdmin/
- Edit the “root” user with password “password” on php my admin, then Login with username root and password “password”.
- Edit the phpmyadmin.conf ; on /etc/httpd/conf.d/phpMyAdmin.conf
phpMyAdmin - Web based MySQL browser written in php Allows only localhost by default But allowing phpMyAdmin to anyone other than localhost should be considered dangerous unless properly secured by SSL Alias /phpMyAdmin /usr/share/phpMyAdmin Alias /phpmyadmin /usr/share/phpMyAdmin Directory /usr/share/phpMyAdmin/ order deny,allow #deny from all allow from 127.0.0.1 allow from 192.168.2.0/24 allow from ::1 /Directory
- Edit the file ; [root@poseidon home]#
vi /etc/phpMyAdmin/config.inc.php
- Edit the part of: insert the password
This is needed for cookie based authentication to encrypt password in cookie / $cfg['blowfish_secret'] = 'password'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! /
- And the part: change from “http” into “cookie”
$cfg['Servers'][$i]['auth_type'] = ‘cookie’; // Authentication method (( config, http or cookie based)?
