phpmyadmin for Debian --------------------- USAGE The application will be available at http://localhost/phpmyadmin/ after install if you use one of supported web servers (Apache and Lighttpd at time of writing this). Please note that you need to have enabled PHP support in your webserver (for Apache you can do this by a2enmod php8.2, for Lighttpd by lighty-enable-mod fastcgi). Should you get a 404 "not found" error when you installed phpMyAdmin using apt-get and point your browser at . Most likely you did not enable configuration for your webserver during installation. You can reconfigure phpmyadmin package to get the selection again and choose webserver you are using (eg. "Apache 2"): sudo dpkg-reconfigure -plow phpmyadmin You can also manually install the shipped configuration file to Apache conf.d directory (but the above way is preferred): sudo a2enconf phpmyadmin PROBLEM WITH COOKIES After upgrading phpMyAdmin with cookie based authentication you might notice a problem with logging in. Removing the cookies from your browser may solve this issue. CONFIGURATION The package installs a default configuration in /etc/phpmyadmin/, including a default apache.conf, which is optionally symlinked from your Apache config. Since 3.0.0, phpMyAdmin can be configured using dbconfig-common. It creates a phpmyadmin database and control user on the chosen server and configures phpMyAdmin to use cookie authentication on this server. The database autoconfiguration might fail if you do not have local MySQL server installed or you have configured too high priority of which questions should debconf ask. To rerun the configuration just invoke: dpkg-reconfigure -plow phpmyadmin The configuration files are processed in following order: 1. /etc/phpmyadmin/config.inc.php 2. possible snippets placed in /etc/phpmyadmin/conf.d/ 3. phpMyAdmin defaults are being applied SECURITY The default configuration for Debian has enabled cookie based authentication. You should *not* put your passwords into /etc/phpmyadmin/config.inc.php file. This file has to be readable by www-data user, so it can be read by anyone who can run his own CGI script! The default configuration also does not allow you to log in with empty passwords, to enable it, set directive AllowNoPassword to true. Register Globals: Debian does not provide security support for installations with the PHP register_globals setting turned On. It's also not required for phpMyAdmin to operate. Make sure it's off. It's trivial to turn it on just for specific legacy sites that may need it. MULTIPLE COPIES FROM ONE CODEBASE The recommended phpMyAdmin way to share an installation between different users is to use cookie or HTTP authentication to support the users, and perhaps define multiple servers in config.inc.php each with their own hostname and other settings. This should be enough for most cases. If you still want to have multiple copies with different configuration, but using the central codebase from the Debian package, the following may be a poor man's solution: mkdir phpmyadmin-site1 && cd phpmyadmin-site1 ln -s /usr/share/phpmyadmin/* . rm config.inc.php cp /usr/share/phpmyadmin/config.inc.php . sed -i 's#/etc/phpmyadmin/config.inc.php/#/etc/phpmyadmin/config-site1.inc.php#' cd /etc/phpmyadmin/ cp config.inc.php config-site1.inc.php vi config-site1.inc.php Make the dir you chose web-accessible and you're done for site1. Copy the created dir to site2 and make the necessary changes, etc. -- Thijs Kinkhorst Mon, 21 Apr 2007 12:10:15 +0200 -- Michal Čihař Wed, 14 Oct 2009 10:32:31 +0200