Installing Apache 2.0.59 to a Windows-based computer, locally: Part 3

• August 26, 2006
• James Skemp

In Part 1 of this Apache 2.0.59 guide, we setup Apache 2.0.59 on a Windows XP SP2 machine. We also setup Perl and mod_perl, attempting to mimic our Apache 1.3.34 install. In Part 2 of this Apache 2.0.59 guide, we setup ColdFusion MX 6.1 and 7.0. This time, we'll be continuing in our quest by adding support for both PHP 4 and PHP 5. In previous guides, we installed PHP 4 and PHP 5, so if you need to install either one, do so with the above directions.

Read More

Installing MySQL Query Browser 1.1.20 on a local Windows-based, Apache, server

• July 8, 2006
• James Skemp

In a previous guide, we installed MySQL and the MySQL Administrator. In this guide, we'll be installing the MySQL Query Browser, version 1.1.20.

Read More

Upgrading phpMyAdmin (2.7.0-pl2 to 2.8.1) on a local, Windows-based, Apache server

• June 20, 2006
• James Skemp

In a previous post, we installed phpMyAdmin 2.7.0-pl2 to our local Web server. We did this so that we would have an easy way to administer our MySQL databases, from a PHP-based interface. This time, we'll be upgrading phpMyAdmin to version 2.8.1.

Read More

WP-ShortStat SQL queries

• April 4, 2006
• James Skemp

The wp-shortstat plugin, modified for WordPress 2.x use by Markus Kaemmerer, is a great little plugin. I've been using it since March 17, and since Markus has been doing a deal of updating (additional functionality, as well as bug fixes), I've been checking it on a regular basis (and have looked through the code more than once). However, since I started out by using 1.3, I've got a problem with old records skewing my stats.

Read More

Adding MySQL connectivity to ColdFusion MX on a local Windows-based, Apache, server

• March 18, 2006
• James Skemp

Until now, we've yet to setup a connection to MySQL from ColdFusion MX. This has meant that while we can do cool database things in PHP (like WordPress), we can't in ColdFusion. Until now. This time, we'll be setting up MySQL 4.1.18 and ColdFusion MX 6.1 on our local server. Because of some of the choices that we've made before, this installation is going to be fairly quick. Setting up MySQL database and user First, we'll need to setup a MySQL database and user for ColdFusion.

Read More

Upgrading (our local install of) WordPress

• March 11, 2006
• James Skemp

In a previous guide, we walked through installing WordPress on a local machine. This time, we'll be upgrading WordPress. For this guide, we'll be upgrading from WordPress 2.0.1 to 2.0.2. Note that this guide will work equally well for upgrading to 2.0.3, 2.0.4 or 2.0.5.

Read More

Setting up WordPress on a local Web server

• February 28, 2006
• James Skemp

In our previous tutorials, we setup an Apache-based Web server, on a Windows XP home computer. The Web server is also running PHP and MySQL, as well as ColdFusion MX. This time, we'll be installing WordPress onto our local Web server. This installation will require us to work with both PHP and MySQL, and we'll be able to setup any number of WordPresses after we have completed this one.

Read More

A local, Apache Web server, on a Windows XP computer

• February 27, 2006
• James Skemp

My intention is to write a number of guides that will help someone build a functional Web server for testing purposes. Since Windows is fairly popular, I've decided to outline how to install Web server programs on it. Since Apache is both powerful and free, I've opted to use it as the core, instead of IIS, or the like. I also plan on keeping the various technologies up-to-date, yet continuing to provide the instructions for past versions used, just in case.

Read More

Installing MySQL Administrator on a local Windows-based, Apache, server

• February 25, 2006
• James Skemp

Last time, we successfully installed both MySQL and phpMyAdmin on our local server. However, we only had one user. This time, we'll be installing MySQL Administrator, to give us the ability to add administer MySQL in a way that we can't do with phpMyAdmin. Before we go, please note that the MySQL Administrator does not take away the value of phpMyAdmin. In fact, phpMyAdmin is usually how you'll be able to administer your MySQL databases in the real world.

Read More

Installing MySQL and phpMyAdmin on a local Windows-based, Apache, server

• February 24, 2006
• James Skemp

Note: This guide should work equally well for phpMyAdmin 2.8.1 and above. For a guide on upgrading this 2.7.0-pl2 install, see Upgrading phpMyAdmin (2.7.0-pl2 to 2.8.1) on a local, Windows-based, Apache server. MySQL will allow us to create databases on our local server. With PHP, this will allow us to install applications like the free WordPress, as well as number of open source content management systems, not to mention bulletin boards and the like.

Read More