Differences
This shows you the differences between two versions of the page.
| — |
en:linux:phpmyadmin [2011/01/15 22:26] (current) matthieu created |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | {{tag>en en:linux en:server en:web en:database}} | ||
| + | ====== PhpMyAdmin ====== | ||
| + | PhpMyAdmin is web interface to administrate [[Mysql]] databases.\\ | ||
| + | :!: Pay attention to secure phpmyadmin access from internet. | ||
| + | |||
| + | ===== Installation ===== | ||
| + | You first need to install [[Mysql]] and a [[serveur web]] with PHP support. | ||
| + | |||
| + | Then to add phpmyadmin, install the package : | ||
| + | * phpmyadmin | ||
| + | |||
| + | Steps during the install : | ||
| + | * which web server to configure : select the server you are using, in our case "apache2" | ||
| + | * Should we configure the phpmyadmin database with dbconfig-common : since version 3, phpmyadmin need a database, using dbconfig-common is a simple way to install it : | ||
| + | * admin password : enter the root password | ||
| + | * phpmyadmin password : leave empty to generate a random one | ||
| + | |||
| + | |||
| + | ===== Configuration ===== | ||
| + | Add the access to phpmyadmin into apache with a configuration similar to : | ||
| + | <file> | ||
| + | <Directory /usr/share/phpmyadmin/> | ||
| + | allow from all | ||
| + | Order deny,allow | ||
| + | </Directory> | ||
| + | </file> | ||
| + | |||
| + | By default, the apache configuration file (///etc/phpmyadmin/apache.conf//) is loaded by a symbolic lynk inside ///etc/apache2/conf.d//.\\ | ||
| + | It is also possible to replace it with a manual load from a config file, for example : | ||
| + | <file> | ||
| + | Include /etc/phpmyadmin/apache.conf | ||
| + | <Directory /usr/share/phpmyadmin/> | ||
| + | allow from all | ||
| + | Order deny,allow | ||
| + | </Directory> | ||
| + | </file> | ||
| + | |||
| + | By default phpmyadmin is available on the website into /phpmyadmin/. | ||
| + | |||
| + | The phpmyadmin configuration is located in ///etc/phpmyadmin///. You can modify here the apache configuration, the access rights, footer and header. | ||
| + | |||
| + | ===== Links ===== | ||
| + | * [[mysql]] | ||
| + | * [[serveur_web]] | ||
| + | * http://www.phpmyadmin.net/ | ||
