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 php5, 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