Setting up Apache, PHP and MySQL on Windows

Installing Apache on Windows

Apache is the backbone of many web projects, and setting it up on a Windows machine is surprisingly straightforward when you follow a clear workflow. First, head over to the official Apache Lounge site – it hosts the most up‑to‑date Windows binaries for Apache HTTP Server. Find the ZIP file for the version you want (for example, 2.4.x) and download it. Once the file lands in your downloads folder, unzip it to a location that will stay consistent; a common choice is C:\Apache24. This folder will hold the server binaries, configuration files, and modules.

Next, open a command prompt with administrative privileges. Running the following command installs Apache as a Windows service, which allows it to start automatically with the operating system and keeps it running in the background without manual intervention:

cd C:\Apache24\bin

httpd.exe -k install -n "Apache24"

After the service registers, start it with:

httpd.exe -k start

You should now see Apache listening on port 80. To confirm, open a browser and navigate to http://localhost. The default Apache welcome page should appear, indicating that the server is functioning correctly. If you see a different page or a connection error, double‑check that no other application is using port 80 (for example, IIS or Skype). If needed, you can change the listening port by editing conf\httpd.conf – find the line that says Listen 80 and replace it with Listen 8080, then restart the service.

Apache’s configuration is highly flexible. The main file, conf\httpd.conf, contains directives that control how the server behaves. Before you start tweaking settings, it’s a good habit to create a backup copy of the original file; simply duplicate it as httpd.conf.bak. Within the configuration you’ll find blocks that enable modules, set document roots, and define virtual hosts. For a beginner setup, it’s enough to point the DocumentRoot to a folder like C:\WebRoot. Create that folder and place a simple index.html inside to test page delivery.

A key part of Apache’s extensibility is its module system. The LoadModule directives in httpd.conf activate optional features. When you add PHP, you’ll later include a module for PHP; for now, make sure the default modules like mod_mime and mod_log_config remain enabled, as they provide MIME type handling and logging respectively.

Security is another important consideration, even for a local development server. Turn on the ServerSignature Off directive to prevent Apache from revealing its version number in error pages. Likewise, change the default AllowOverride None setting for the root directory to AllowOverride All if you plan to use .htaccess files for per‑directory configuration. After editing, always restart Apache to apply changes. Keep the service running by using the Service Manager (services.msc) – you can set it to “Automatic” so that it starts with Windows.

At this point Apache is fully operational on your Windows machine. You’ve installed the core binaries, registered the service, verified connectivity, and tuned a few critical configuration options. With Apache in place, you’re ready to integrate PHP and then bring a database layer into the mix. Each subsequent section will build on this foundation, ensuring a cohesive, functional development environment that mirrors a typical production stack.

Installing PHP for Apache on Windows

PHP is the scripting language that turns static HTML pages into dynamic web applications. Installing it on a Windows system requires a few careful steps to make sure it talks properly with Apache. Begin by visiting the official PHP Windows download page. Choose the “Thread Safe” ZIP archive that matches the version of Apache you installed – for example, php-8.3.5-Win32-VC15-x64.zip. Download the file and extract its contents to C:\php. This folder will house the PHP binaries, configuration file, and extensions.

The first thing you’ll need to tweak is the php.ini file. Inside C:\php, find php.ini-development and copy it to php.ini. This will serve as your main configuration. Open php.ini in a text editor and set the extension_dir directive to point to the folder containing extensions:

extension_dir = "C:/php/ext"

Also enable the necessary extensions for typical web development. Search for the lines that begin with a semicolon (;) and remove it from the following directives:

extension=mysqli

extension=pdo_mysql

extension=openssl

extension=gd

This activates MySQLi, PDO, OpenSSL, and GD, which are commonly used for database access, encryption, and image processing.

Now you must tell Apache how to hand PHP requests over to the PHP interpreter. Open the Apache configuration file at C:\Apache24\conf\httpd.conf. Add the following lines near the end of the file, but before any virtual host declarations:

LoadModule php_module "C:/php/php8apache2_4.dll"

AddHandler application/x-httpd-php .php

PHPIniDir "C:/php"

These directives load the PHP module into Apache, associate the .php file extension with PHP processing, and specify the directory where PHP’s php.ini resides. Be sure the module name matches the PHP version you installed – for PHP 8.x the file is usually php8apache2_4.dll

After editing httpd.conf, restart Apache to apply the new configuration. The simplest way to verify that PHP is working is to create a file named info.php inside the web root (C:\WebRoot). Put the following code inside:

<?php phpinfo(); ?>

Open a browser and go to http://localhost/info.php. If PHP is correctly integrated, you’ll see a detailed page showing PHP’s configuration, loaded extensions, and environment variables. This page confirms that Apache can parse PHP scripts and that PHP can access its own configuration file.

Fine‑tuning PHP for a development environment includes enabling error reporting. In php.ini, set:

display_errors = On

error_reporting = E_ALL

These changes cause PHP to output warnings and notices directly in the browser, which is helpful when debugging scripts. For a production server you’d disable display of errors and log them instead. Also, consider setting the date.timezone directive to match your local time zone to avoid PHP throwing “time zone not set” warnings.

With PHP properly configured, you have a dynamic scripting engine that can respond to requests routed by Apache. The next logical step is to add a database layer, enabling your applications to store and retrieve data. The following section will walk you through installing MySQL and connecting it to PHP, completing the LAMP‑style stack on a Windows machine.

Installing MySQL on Windows

MySQL provides the relational database management system that many PHP applications rely on. While MySQL is available for multiple operating systems, the Windows installer offers a straightforward experience. Start by downloading the ZIP archive for the community edition from the official MySQL website. Choose the platform‑specific ZIP (for example, mysql-8.2.0-winx64.zip) and unzip it to C:\MySQL. Inside, you’ll find a bin folder, several library directories, and a my.ini template.

The most common approach to running MySQL on Windows is to install it as a service. Open a command prompt with administrator rights and navigate to the bin folder. Run:

mysqld --initialize-insecure --user=mysql

This command creates the data directory and generates default system tables. The --initialize-insecure flag sets a blank root password – suitable for local development, but be sure to secure it before exposing the server to a network. Next, register MySQL as a service:

mysqld --install MySQL

Start the service with:

net start MySQL

You can now test connectivity using the MySQL command line client. In the same bin directory, type:

mysql -u root

You should land at the MySQL prompt. To confirm that the server is responsive, run a simple query:

SELECT VERSION();