Note: By default, everyone who can reach the Apache Web Server can see the phpMyAdmin login page under this URL. To change this, edit /etc/httpd/conf/extra/phpmyadmin.conf to your liking. For example, if you only want to be able to access it from the same machine, replace Require all granted by Require local. Beware that this will disallow connecting to PhpMyAdmin on a remote server. If you still want to access PhpMyAdmin on a remote server securely, you might want to consider setting up a Secure Shell#Encrypted SOCKS tunnel.

Lighttpd

Configuring Lighttpd is similar to Apache. Make sure Lighttpd is setup to serve PHP files (see Lighttpd).

Add blowfish_secret passphrase

It is required to enter an unique string (32 characters are recommended) to fully use the blowfish algorithm used by phpMyAmdin, thus preventing the message ERROR: The configuration file now needs a secret passphrase (blowfish_secret):

/etc/webapps/phpmyadmin/config.inc.php

$cfg['blowfish_secret'] = '...';

Enabling Configuration Storage

Extra options such as table linking, change tracking, PDF creation, and bookmarking queries are disabled by default, displaying The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. on the homepage.

Note: This example assumes you want to use the default username pma as the controluser, and pmapass as the controlpass.

In /etc/webapps/phpmyadmin/config.inc.php, uncomment (remove the leading "//"s), and change them to your desired credentials if needed:

Setup database user

To apply the required permissions for controluser, execute the following query:

Note: Make sure to replace all instances of pma and pmapass to the values set in config.inc.php. If you are setting this up for a remote database, then you must also change localhost to the proper host.