How to install phpMyAdmin

This guide shows how to install phpMyAdmin - an easy to use adminitration tool for mysql database.

Install mysql database

This issue has been described here: How_to_install_MySQL

Install PHP and www server

This issue has been described here: How to install WWW server with PHP support

Install phpMyAdmin

Download phpMyAdmin from phpMyAdmin.net. Unpack it to /var/www/htdocs/. You can symlink the new directory with long name (ie. phpMyAdmin-3.3.8-english) to /var/www/htdocs/phpmyadmin in order to simplify the address. Go to the above directory and create the config file using the attached sample:

cp config.sample.inc.php config.inc.php

Edit this file - find the line $cfg['blowfish_secret'] = ; and define this entry in order to enable authentication with cookies:

$cfg['blowfish_secret'] = 'something' ;

make sure $cfg['Servers'][$i]['auth_type'] is set to cookie:

$cfg['Servers'][$i]['auth_type'] = 'cookie';

At this moment phpMyAdmin should work. If you symlinked its orginal directory to /var/www/htdocs/phpmyadmin it should be accesible via your browser. If it is not then computer reboot is necessary in order to make phpMyAdmin work properly (unknown reason).