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