PHPMyAdmin installation

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/.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>