Apache, MySQL & PHP for Windows

Apache, MysQL and PHP for Windows could be a nice nice thing to have on your Windows workstation. You could try and experiment with all kinds of nice PHP and MySQL based applications right on your Windows desktop running Apache, instead of having to access a full-featured server.

Most people have Windows as their workstation and it can be sometimes difficult to switch to another operating system. So, you may have always wanted to run PHP applications on your Windows machine but wondered if it is too difficult to install or if the hassle will be worth it.

This article gives you the essential information to get started right away. Even if you are a seasoned PHP, MySQL and Apache guru, the checklist below will still be helpful in your installation process.

There are lots of 3rd party software that bundles Apache, MySQL & PHP in one package and installs them on our computer. We do not recommend this and suggest that you directly get Apache, MySQL & PHP from their official sites.

Apache

1. Get Apache 1.3.33 from here: http://httpd.apache.org/download.cgi.

2. Choose a mirror close to you and in the same page, look for the Win32 Binary (Self extracting) file: apache_1.3.33-win32-x86-no_src.exe.

3. Download the file and save it on your hard disk. Run the installer and the self- extracting wizard will guide you through the rest of the steps. Choose all the default settings and run Apache as a service.

4. Remember to put "localhost" when asked for a Server name/Domain name. Use "administrator@localhost" when asked for the administrative email account.

5. Now point your browser to: http://localhost and you should see an Apache Test Page.

6. You can change this page by creating an "index.html" page here "C:Program FilesApache GroupApachehtdocs".

7. You can manually start and stop the Apache server. In a Windows command prompt, type "net stop apache" or "net start apache".

MySQL

1. Get MySQL 4.1.7 from here: http://dev.mysql.com/downloads/mysql/4.1.html

2. Under the Windows downloads section, choose Windows Essentials (x86) and click on the Pick a Mirror link.

3. Download the file mysql-4.1.7-essential-win.msi and save it on your hard disk. Run the installer and the self-extracting wizard will guide you through the rest of the steps. Remember the root password when prompted for it in the installation process.

4. Once the installation is done, on your Windows toolbar, go to "Start->Programs- >MySQL->MySQL Server 4.1->MySQL Command Line Client".

5. Type the root password and you should be logged in to the MySQL shell.

6. Type "show databases;" to see the list of databases. Type "quit" when you are done.

PHP

1. Get PHP 4.3.10 from here: http://www.php.net/downloads.php

2. Under the Windows Binaries section, choose the file: PHP 4.3.10 zip package size 7,405Kb dated 15 Dec 2004.

3. Download the file and save it on your hard disk. Unzip the file and rename the extracted folder to "php". Now move this folder "php" and place it under "C: Program Files".

4. Move all the files under "C:Program Filesphpdlls" and "C:Program Filesphpsapi" to here: "C:Program Filesphp".

5. Copy the file php.ini-recommended to "C:WINDOWS" and rename it to php.ini

6. Edit your Apache "httpd.conf" configuration file located here: "C:Program FilesApache GroupApacheconf".

7. Add the following lines in httpd.conf:

LoadModule php4_module "C:/Program Files/php/php4apache.dll"
AddModule mod_php4.c
AddType application/x-httpd-php .php

8. Now stop your server by issuing the following command in Windows command prompt: "net stop apache". Then type "net start apache" to start your server. We are now going to test the PHP installation.

9. Go to "C:Program FilesApache GroupApachehtdocs" and create a file test.php

10. Edit test.php and add the following code:

11. Point your browser to http://localhost/test.php and you should see a lot of PHP configuration information.

Congratulations! You now have Apache, MySQL and PHP installed in your computer. Now you can install your favorite script right on your Windows workstation.

Sanjib Ahmad, Freelance Writer and Product Consultant for Business.Marc8.com - Business Best Sellers.

You are free to use this article in its entirety as long as you leave all links in place, do not modify the content, and include the resource box listed above.

---

Favorite Things To Do With Home Technology

Save money. Save 10-15% on utility bills per month. Work... Read More

Image Formats: GIF, JPEG, BMP

When browsing the internet you are likely to come across... Read More

EDTV: What You Should Know Before You Make That Purchase

Enhanced Definition Television ? also known as EDTV ? is... Read More

The Ipod Mini: Why Its Not that Hot

I got my eyes set on a iPod mini, as... Read More

Why There Are Color Differences in Printing from Your PC

This article describes the basic properties of color, what the... Read More

The Importance Of Email Backup

Viruses, software failures, power failures, human errors, hard drive failures... Read More

USB Drives - What to Look For in a USB Device

Those small USB drives have so many names, pocket drives,... Read More

Cisco CCNA Certification: Five Things To Do DURING The Exam

There are plenty of articles out there about how to... Read More

Connect Your IPAQ to Linux

Choose Not To ConformPalm pilots and pdas are constantly growing... Read More

Plasma TV vs LCD TV

For those seeking to buy their first flat panel TV... Read More

Buying a Personal Computer (PC)

For many people the computer industry is a seeming unsolvable... Read More

Email Management

If you utilize a computer at home or work it... Read More

SOBIG.F Virus Promises Ill Be Back

On 21 August 2003 Symantec Security Response upgraded the W32.SOBIG.F... Read More

5 Steps to Removing PC Clutter

It's hard enough as it is these days to get... Read More

Microsoft Great Plains Dexterity Customizations

Microsoft Business Solutions is on the way to popularize it's... Read More

The Advantages of Portable MP3 Players

With their solid-state technology, compact size, and abundant memory, portable... Read More

Emulation Manual - A Complete Guide on How to Change Your Windows XP to Mac OS X

IntroductionMac OS X is the most technologically advanced operating system... Read More

Passwords and the Human Factor

Passwords have a strange dual nature. The stronger and safer... Read More

Faster Browsing Tips

IF WE say that it was mainly because of the... Read More

Taking Advantage of the iPod Experience

Music lovers have been carrying around radios and other bulky... Read More

Portable Technology: Getting to Know the Treo

Up until the recent past, those who wanted to take... Read More

Are You Well Protected?

Winter?the official start of the cold and flu season. Though,... Read More

If You are the Only User on Your Windows XP Computer, Do You Think One User Account Is Enough?

I am going to assume that you are running windows... Read More

System File Checker - A Maintenance Utility

System File Checker is a great utility that is typically... Read More

Advantages and Guidelines of Automated Testing

"Automated Testing" is automating the manual testing process currently in... Read More

Selecting the Perfect Big Screen TV

Selecting a TV isn't as easy as it used to... Read More

Help, I Need a New HDTV! (Part 2 of 5)

Feeling overwhelmed in selecting a new TV? With all the... Read More

Nephrology and Dialysis For a PDA

Saving Lives With A Pocket PCFree medical downloads can be... Read More

Three Things You Can Do to Keep Your Computer Running at Maximum Performance

Although there are many things that can affect the performance... Read More

Gain Control Over Your Screensavers With These Simple Steps

We all enjoy our favorite screensavers but in the same... Read More

Your Affiliate Business - Peripherals, Software, Computers

I have always been interested in computers, but in the... Read More

2 PC Annoyances and How To Solve Them!

I have a love-hate relationship with my computer.In fact, often... Read More

What Are You Looking For In A Cheap MP3 Player?

Are you stymied by the vast offerings in cheap mp3... Read More