PHPMyAdmin installation
Nov 22, 07 by Juan Lebrijo about Administration, blog, MySQL
PHPMyAdmin is an administrator of the MySQL data base. Administraton application developed in PHP. We can publish it in a web server and administer securely our MySQL DBMS remotely, with the only requisite of a web browser. We are going to installa it in a LAMP server (Linux+Apache+MySQL+PHP). As usually I give us my reference table: Origin http://www.phpmyadmin.net Repository http://www.phpmyadmin.net/home_page/downloads.php Package phpMyAdmin-2.11.0-all-languages.tar.gz Documentation (english) http://wiki.cihar.com/pma/Welcome_to_phpMyAdmin_Wiki Installation in the shell:
  • Unzip, and move the directory to the web root:
tar -zxvf phpMyAdmin-2.11.0-all-languages.tar.gz
mv phpMyAdmin-2.11.0-all-languages /var/www/mysql
  • Copy the generic configuration file to the real one:
cd /var/www/mysql
cp config.sample.inc.php config.inc.php
Configuration file /var/www/mysql/config.inc.php config our application:
  • Fill the aleatorious phrase for identifing of the connection cookies:
$cfg['blowfish_secret'] = 'aiffa30-8/36+k20dm39okdsn';
  • To use the new funcionalities:
$cfg['Servers'][$i]['extension'] = 'mysqli';
  • Config web access user:
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'contraseña-super-segura';
The web access is: http://tuservidor.com/mysql/.