Installing phpMyAdmin

Guide on how to install phpMyAdmin on FreeBSD

Phpmyadmin is a web interface for administrating MySQL. Now this is for the people out there who don’t have the time or interest in learning how to administrate MySQL by command line arguments.

Installing phpMyAdmin on FreeBSD is really quite simple and easy. This guide will help you install phpMyAdmin from ports.

Accept the default values and hit ok [Screenshot] If “Improved MySQL Support is checked uncheck it”

Before you continue I recommend creating a superuser other than root to be used in conjunction with phpMyadmin and MySQL. To do this follow the next step. If you rather would like to use root which I strongly advise against you can simply skip the next step.

replace “user” and “password” with the real user and password you would like to use.

Now we need to edit the configuration file for phpMyAdmin

Add a password between the two ' ' so it will look like below

Remove the two // and change “pma” to the username you want to use when you log on to the web interface.

Remove the two // and change “pmapass” to the password you want to use when you log on to the web interface.

We need to modify apache’s httpd.conf file so we can access phpMyAdmin from http://www.yoursite.com/phpmyadmin

And add the following lines below it. “IP-Number” is the IP numbers you want to allow access to the web interface separated by “space”. Now this is strongly recommended as a security enhancement.