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';
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'contraseña-super-segura';
The web access is: http://tuservidor.com/mysql/.