Setting Up phpMyAdmin

General Information

If you are a point-and-click kind of person and have to manage one or more MySQL servers, you may find this web-based utility to be a goldmine.


  1. Local root access on the box or be able to su to root.
  2. A SSH client such as puTTy or SecureCRT (if you aren’t on the box).
  3. Your favorite text editor (I prefer nano).


Installation is straight forward. Either download the source from or install it from your favorite package manager. I will be installing it on FreeBSD using the ports tree. If you grabbed the source, just extract it to whichever directory you want it to be accessed from the web. If you install it via ports or packages, it will get installed in /usr/local/www/phpMyAdmin.

# cd /usr/ports/databases/phpmyadmin
# make install clean


The configuration of the newer versions (2.7.x and above) can be done by pointing your browser to or whatever virtualhost you are using. Now, what we effectively want to accomplish is populating /usr/local/www/phpMyAdmin/ with the proper settings that you want. Once you loaded the setup script in your browser, run through all of the setup options configuring what you need. A quick and dirty setup includes adding the server you are connecting to with cookie authentication. Now there are a couple of ways to save this configuration.

Method One

Once you click ‘Add’ click ‘Display’ and copy all of the php text, open a ssh connection to your phpMyAdmin server and paste it into /usr/local/www/phpMyAdmin/

Method Two

Click ‘Add’ as above, but this time you want to make the file writable by the web server so you can save your configuration from the web interface.

Note: This method is the least secure because anybody could change your config file, so use with caution.
# cd /usr/local/www/phpMyAdmin
# chmod g+w

Make your changes in the setup page and then click ‘Save’ to save to the writable config file.

Now point your browser to your phpMyAdmin site and log in using your MySQL credentials. Enjoy.

Speak Your Mind