Adding phpMyAdmin to Ubuntu system.

OK – so where are we?

We have a working Apache2 server. We’ve created a couple of Virtual Hosts, and can access them from the outside world via dyndns.com.

What’s next – setting up a usable mySQL system. The easiest way to maintain multiple mySQL databases is with phpMyAdmin. This is a standard Ubuntu package, and is very easy to install to run from the default Apache host. But a couple of notes first.

Note that ‘localhost’ is the default mySQL server name assumed by a lot of php software packages that you’re likely to use (such as WordPress). And under the setup we’ve built so far, it is the default site that is ‘localhost’. You can see this by opening a Firefox browser inside your Ubuntu VM (or real hardware), and entering “http://localhost” to the address box – and you will get the home page of the default host – which still should be at /var/www/.

Note that any domain names you’ve defined using dyndns.com to map to your Ubuntu server will use the default site unless you’ve set up some virtual site hosts. In the default configuration, /var/www/ is owned by root. This isn’t easy to work with – edit, etc. There are at least three ways to make it easy for you to use the default host directories. The laziest is to just chown and chgrp /var/www/ to your own username/group. You also could change the default Apache site configruation file to use a directory on your own home directory, or you can use symbolic links. I used chown.

OK – so let’s install phpMyAdmin on the default localhost directory. Here’s what you have to do. From a terminal, enter: sudo apt-get install phpmyadmin. It’ll do the usual stuff, and now it is ready to go. To use it, simply enter “http://localhost/phpmyadmin” into your local browser, or a domain name that maps to the default host from any browser. I won’t go into the details of using phpMyAdmin here.

I would just like to say I set up a similar Ubuntu server over a year ago, and it was not at all this easy. It seems to me you can start from scratch and install and build a complete Ubuntu 8.10 Desktop with Apacache2, mySQL, php5, and phpMyAdmin in less than two hours. I hope your installation goes as smoothly.

Next – WordPress.

Advertisements

About brucewampler

I've had a long and varied careen in the computer industry. I taught computer science at the University of New Mexico for nearly 15 years. I founded two successful computer software companies. I wrote the first spelling checker and first grammar checkers for personal computers. I've lived in Glenwood Springs for 10 years. My wife, Trina, grew up here, and I've been coming to Glenwood since 1977. My kids have attended the local public schools, and have had a great experience. My son, Van, will be attending the University of Colorado starting in the fall of 2007, and my daughter is a Sophomore at Glenwood Springs High School. I've been on the Roaring Fork School District Board of Education for almost 5 years. Working with our kids, teachers, schools, principals, administrators, and the Roaring Fork community has been one of the most rewarding experiences in my life.
This entry was posted in LAMP. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s