A.W.Colley Family | WebsiteDevelopment/Apache-MySQL-PHP for Windows

Websites

www.chsoftware.net/en/useware/wos/wos.htm — WOS (Webserver on Stick)
www.uniformserver.com/index.php?us=news — The Uniform Server

Reference

PHP Documentation with user comments
MySQL Reference Manual with user comments
Apache HTTP Server Version 2.0 Documentation

An incomplete attempt

At work, I wanted to get TikiWiki running on a Windows XP computer. As I was installing the various components, I kept track of the steps involved. However, I never did get around to finishing up the MySQL installation because I decided I didn’t really need TikiWiki there after all. If one wanted to set up PmWiki (which is what awcfamily.com is now using) on Windows XP, you would only need Apache and PHP anyway.

Installing Apache

Use the msi installer for Apache. Obtain the latest version from httpd.apache.org/download.cgi – click on "Other files", then "binaries", then "win32", then look for the .msi file with the highest version number.
Run it and fill in the blanks as required.
Change the DocumentRoot to C:\htdocs (use Apache⇒Configure⇒Edit from the start menu). You also need to change the <Directory …> where the comment says “This should be changed to whatever you set DocumentRoot to.” Create the directory (you may want to copy the images and appropriate index.html from the default htdocs directory under Program Files for testing).
Test it by browsing to http://localhost.

Installing PHP

Use the zip package for PHP. Obtain the latest version from www.php.net/downloads.php.
Extract the contents of the zip into C:\php.
Add C:\php to your PATH.
Open C:\php\php.ini-recommended in Notepad:
1. Set doc_root = c:\htdocs
2. Set extension_dir = c:\php\ext
3. Increase memory_limit
4. Increase upload_max_filesize
5. Decide which extensions to load. Probably at least gd2 and mysql (if you are going to install MySQL).
6. Save As… php.ini
Edit the apache configuration file, adding the following lines after all the other LoadModule lines:
```
    LoadModule php5_module "c:/php/php5apache2.dll"
    AddType application/x-httpd-php .php
    PHPIniDir "C:/php" 
```
(For Apache 2.2., use php5apache2_2.dll instead)
After saving the apache configuration file, you MUST reboot. I know this is WindowsXP and you shouldn’t have to, but PHP will complain about not being able to find php_mysql.dll if you do not reboot (oddly, it does find php_gd2.dll without rebooting).
Create a simple little index.php file in htdocs; in it have a call to phpinfo. Test it out in a browser at http://localhost/index.php.

Installing MySQL

Use the zip package for MySQL. Obtain the latest version from dev.mysql.com/downloads/.
Run the setup program in the downloaded zip file. The “Typical” installation is fine. The “MySQL.com Sign-Up” is optional. Choose to configure the MySQL server.
1. Select Detailed Configuration.
2. Choose Developer Machine.
3. Choose Multifunctional Database.
4. Use the defaults for the InnoDB Tablespace Settings.
5. Choose Decision Support (DSS) / OLAP.
6. Disable TCP/IP Networking (we do not want our MySQL server to serve the world, only our local applications).
7. Choose the Standard Character Set.
8. Select Install As Windows Service and Include Bin Directory in Windows PATH.
9. Specify a new root password, and do NOT enable root access from remote machines. Do NOT Create An Anonymous Account.
10. Execute the configuration.
where I stopped