Nethence Newdoc Olddoc Lab Your IP BBDock  


Warning: those guides are mostly obsolete, please have a look at the new documentation.

UnixWindowsOracleObsoleteHardwareDIYMechanicsScriptsConfigs

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.
 

(obsolete, see the new doc)