this is obsolete doc -- see http://doc.nethence.com/ instead

phpMyAdmin 2.x configuration 

 

 

Introduction 

PHP 5.2+ is required for phpmyadmin 3.x, son on RHEL5 we keep using v2.x. 

 

 

Installation 

Fetch the latest 2.x stable release (http://www.phpmyadmin.net/home_page/downloads.php) and untar it to somedir/ e.g., 

cd ~/
wget "http://freefr.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/2.11.11.3/phpMyAdmin-2.11.11.3-english.tar.gz"
tar xzf phpMyAdmin-2.11.11.3-english.tar.gz
mv phpMyAdmin-2.11.11.3-english/ /var/www/vhosts/local.example.apache/myadmin/

 

Cookie auth is just fine, 

cd /var/www/vhosts/local.example.apache/myadmin/
sed '/^\//d; /^ \*/d; /^$/d' config.sample.inc.php > config.inc.php
vi config.inc.php

then change, 

$cfg['blowfish_secret'] = 'ANYTHING HERE';
$cfg['Servers'][$i]['extension'] = 'mysqli';

Note. otherwise you can always use apache authentication methods, see http://pbraun.nethence.com/doc/www/apache.html 

 

 

Ready to go 

Verify your access as mysql root, 

mysql -uroot -p

 

Point your browser to phpmyadmin, 

http://WEB_SERVER/

Note. you might experience some cache troubles. If so, flush you browser's cache. 

 

 

Fix users & privileges 

See the "Databases" and "Privileges" tabs. Make sure each user has only grant access to its own database. Also eventually remove the second root user, the local one is enought.