phpMyAdmin Installation on Ubuntu Server 8.04

Since managing a MySQL database through a command line is tedious we will be installing a web-based GUI so we can access MySQL through any web browser on any computer.

On many Unix machines you’d have to go to the phpMyAdmin homepage and download the files there, decompress them and set up a config files before you could get to managing your database.  If you’re setting up several machines to work in a cluster you have better things to do with your time. This is why I love Debian/Ubuntu distrobutions.

apt-get install phpmyadmin

During the install process you will be asked which version of Apache you are running.  Ubuntu Server Edition uses Apache 2.2, so it wont be automatically configured for you.  After the install process completes you will need to configure Apache 2.2, so in your favourite text editor open up /etc/apache2/apache2.conf and search for the word include.  Add a new line next to its first match like this:

Include /etc/phpmyadmin/apache.conf

Save the file, exit to your command line and restart Apache with the following command:

/etc/init.d/apache2 restart

Your phpMyAdmin installation is now ready to use. Point your browser to http://domain/phpmyadmin/ and log in with your mySQL username and password.  It’s that simple!

Tags: , , , , , ,

  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments

Setting up a LAMP Server with Ubuntu Server Edition 8.04

Our first installment of the Ubuntu Server Edition series will consist of installing Ubuntu and configuring it to run as a LAMP (Linux Apache MySQL and PHP) server.  We will be using the Server Edition there will be no GUI installed unless you do so manually.  Since we want optimal performance, we will not be doing that today.  So if you’re not comfortable with a command line, this tutorial is not for you.

To start off you’re going to need a copy of Ubuntu Server Edition 8.04 which can be downloaded from their website or you can order free CDs.  You’ll also need a computer that has a network connection, a CD-ROM and you’ll need a keyboard and monitor for the initial stages.  Today I am using a 500mhz Pentium III computer that I’ve had lying around for years. It has 1.5gb of RAM, a 4.3gb HDD and a Radeon 8500 in it plus a generic NIC card.  Despite how old this computer is it will be able to do quite a bit of work since it wont have the overhead of a GUI and Linux is so much more efficient as a web server than Windows.

Pop in your disc, and boot up the computer.  You may need to enter your setup and configure it to boot off of a CD (or a USB stick if that’s what you’re using).

UNDER CONSTRUCTION
-describe install steps here-

  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments

Dreamweaver 8 Forgets FTP Accounts on Exit

I’m in a really good mood right now because I just found a fix for a bug that’s been driving me up the wall for a long time.  I’ve been using Dreamweaver for a long time, but just in the past few months I’ve noticed an issue where everytime I closed and reopenned the program it forgot the username and password for every single FTP account I had saved.  I knew this problem hadn’t been around forever as I have used this version for a long time before it started happening.  After finally taking the time to do some research on the matter I discovered that the issue was caused by installing IE7 (or IE8). Somehow that process induced a bug in Dreamweaver and it could be solved simply by updating to 8.0.2.  Fancy that.

Tags: , , , , , , ,

  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments
 Page 69 of 71  « First  ... « 67  68  69  70  71 »