phpMyAdmin Setup Interface

phpMyAdmin can be configured through it’s usable setup interface (something like http://localhost/phpmyadmin/setup). In most cases, you’ll have to authenticate first to access the panel. The credentials for this authentication can be found in /etc/phpmyadmin/htpasswd.setup file. You’ll probably have to generate a password before doing anything else. You can do that online. I tend to use this website.

Note that I’m using Ubuntu 10.04 and phpMyAdmin version 3.3.2deb1.

phpMyAdmin Apache configuration

Even if you’ve installed phpMyAdmin via packet manager, it’s possible that you can’t reach it’s web panel. That’s probably because you’ve not defined phpMyAdmin’s Apache configuration. In order to do that, you can create a symbolic link to phpMyAdmin’s default Apache configuration file under the /etc/apache2/conf.d directory like this:

sudo ln -s /etc/phpmyadmin/apache.conf phpmyadmin.conf

Then restart your server by typing:

sudo /etc/init.d/apache2 restart

And you’re ready to go!