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