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:

Package phpMyAdmin-2.11.0-all-languages.tar.gz
Documentation (english)

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

Configuration file /var/www/mysql/ 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:

Leave a Reply

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