HOWTO install Phpmyadmin 3.1.2 - Ubuntu

HOWTO Install PhpmyAdmin to manage MYSQL Server - Ubuntu 8.04


1.- Download PhpMyAdmin from official site

Last version: PhpMyAdmin 3.1.2
Released: Mon, 19 Jan 2009

WEB http://www.phpmyadmin.net/home_page/index.php
Package: phpMyAdmin-3.1.2-all-languages.tar.gz

From console:

root@server:/var/www# wget http://ufpr.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-3.1.2-all-languages.tar.gz

Ouput:

--09:27:02-- http://ufpr.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-3.1.2-all-languages.tar.gz
=> `phpMyAdmin-3.1.2-all-languages.tar.gz'
Resolviendo ufpr.dl.sourceforge.net... 200.236.31.1, 200.17.202.1
Conectando a ufpr.dl.sourceforge.net|200.236.31.1|:80... conectado.
Petición HTTP enviada, esperando respuesta... 200 OK
Longitud: 3,602,103 (3.4M) [application/x-gzip]

100%[====================================>] 3,602,103 412.97K/s ETA 00:00

09:27:11 (399.08 KB/s) - `phpMyAdmin-3.1.2-all-languages.tar.gz' guardado [3602103/3602103]

2.- Uncompress file, rename and change owner ( inside /var/www )

root@server:/var/www# tar -xzvf phpMyAdmin-3.1.2-all-languages.tar.gz
root@server:/var/www# mv phpMyAdmin-3.1.2-all-languages phpmyadmin
root@server:/var/www# chown -R www-data:www-data phpmyadmin/

3.- Configure with setup script

root@server:/var/www# cd phpmyadmin
root@server:/var/www/phpmyadmin# vim config.inc.php

Edit config.inc.php
Mode: Cookie (Asked for a user&password every time)

07d650037c1ec''; // use here a value of your choice

$i=0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
#activate ONLY if You want to access directly, without user/passwd question
#$cfg['Servers'][$i]['auth_type'] = 'config';
#$cfg['Servers'][$i]['user'] = 'root';
#$cfg['Servers'][$i]['password'] = 'rootmysqlpass';
#$cfg['Servers'][$i]['connect_type'] = 'tcp';

?>

4.- Access Phpmyadmin

Access:

Panel:



5.- More details
http://wiki.cihar.com/pma/Quick_Install