DEV Community

Cover image for A Complete Guide to Install XAMPP, Configure Apache & MySQL Services, and Deploy WordPress Using PowerShell Commands
Dulan Nithila Liyanarachchi
Dulan Nithila Liyanarachchi

Posted on Originally published at linkedin.com AI-assisted

A Complete Guide to Install XAMPP, Configure Apache & MySQL Services, and Deploy WordPress Using PowerShell Commands

Setting up a reliable local web development environment is one of the first steps for anyone working with WordPress, PHP, MySQL, or Apache. While XAMPP makes this process easier by bundling the required components into a single package, configuring the environment properly, especially through the command line, can still be challenging.

Many online tutorials focus only on the graphical interface and often skip essential configuration steps, troubleshooting techniques, or service management. As a result, beginners frequently encounter issues with Apache, MySQL, PHP compatibility, phpMyAdmin, or WordPress installation.

To address these challenges, I created a comprehensive guide that demonstrates how to install, configure, and manage an entire XAMPP and WordPress development environment using Windows PowerShell.

Whether you're a student learning web technologies, an educator preparing laboratory sessions, or a developer looking for a repeatable deployment process, this guide provides a structured approach from start to finish.

Why This Guide?

A properly configured local development environment saves hours of troubleshooting and creates a consistent workflow for development, testing, and learning.

Instead of relying solely on mouse clicks, this guide introduces a command-driven approach that helps users understand what happens behind the scenes while also making the installation process easier to reproduce across multiple machines.

The guide follows a complete workflow covering installation, service management, WordPress deployment, version upgrades, and troubleshooting.

What You'll Learn

The guide covers every major step required to build a local WordPress development environment.

1. XAMPP Installation

Learn how to install XAMPP using PowerShell commands, verify the installation, and safely uninstall and reinstall it when necessary.

Topics include:

  • Downloading XAMPP
  • Silent installation
  • Installation verification
  • Troubleshooting incomplete installations
  • Safe uninstallation

2. Apache Service Configuration

Apache is configured as a Windows Service, allowing it to be managed directly through PowerShell.

You'll learn how to:

  • Install Apache as a service
  • Verify service status
  • Start and stop Apache
  • Manage services efficiently
  • Troubleshoot service-related issues

3. MySQL Service Installation

Database configuration is an essential part of every WordPress deployment.

This section explains how to:

  • Install MySQL as a Windows Service
  • Verify successful installation
  • Start and stop the service
  • Prepare the database environment for WordPress

4. WordPress Deployment on XAMPP

One of the largest sections of the guide walks through deploying WordPress on a local server.

Topics include:

  • Creating WordPress databases
  • Configuring users and permissions
  • Downloading WordPress
  • Extracting and organizing files
  • Running the installation
  • Configuring the initial website
  • Accessing the WordPress dashboard

5. Upgrading PHP

Modern WordPress versions require newer PHP releases.

The guide explains how to safely:

  • Replace outdated PHP versions
  • Configure php.ini
  • Enable required PHP extensions
  • Update Apache configuration
  • Verify the installation

6. Upgrading phpMyAdmin

Many bundled XAMPP installations include older versions of phpMyAdmin.

The guide demonstrates:

  • Installing the latest release
  • Preserving existing configurations
  • Migrating settings safely
  • Verifying successful upgrades

7. Daily Service Management

Instead of opening the XAMPP Control Panel every time, the guide shows how to manage services directly from PowerShell.

This includes:

  • Starting Apache
  • Starting MySQL
  • Opening WordPress
  • Accessing phpMyAdmin
  • Stopping services after development

Why Use PowerShell Instead of Only the XAMPP Control Panel?

Learning to manage services through PowerShell provides several long-term advantages.

  • Faster setup
  • Easier automation
  • Better troubleshooting
  • Repeatable deployments
  • Improved understanding of Windows service management
  • Practical DevOps and system administration skills

These skills become increasingly valuable when working with larger development environments or automating deployments.

Who Should Read This Guide?

This guide is suitable for:

  • Web Developers
  • WordPress Developers
  • PHP Developers
  • Computer Science Students
  • Information Technology Students
  • Software Engineering Undergraduates
  • Lecturers and Instructors
  • System Administrators
  • Beginners learning local web development

It is especially useful in academic environments where students need to deploy multiple local development environments using consistent procedures.

GitHub Repository

The complete guide and supporting resources are available on GitHub.

GitHub Repository:

XAMPP-WordPress-PowerShell-Guide

If you find this resource useful, consider giving the repository a star. It helps increase visibility and encourages further improvements.

Also Published On

This article is also available on the following platforms:

Acknowledgements

I would like to express my sincere gratitude to Mr. Madusanka Mithrananda for his invaluable guidance, encouragement, and continuous support throughout the development of this guide and the article. His expertise, constructive feedback, and mentorship were instrumental in shaping this work and deepening my understanding of XAMPP, PowerShell, and WordPress deployment.

I truly appreciate his dedication to teaching, willingness to share knowledge, and the encouragement provided throughout this journey. His guidance has been an invaluable part of the successful completion of this guide.

Final Thoughts

Documentation is one of the most valuable yet overlooked contributions to the developer community. A clear, repeatable guide can save countless hours for students, developers, and educators trying to build reliable development environments.

This project was created with the goal of simplifying the setup process while encouraging developers to understand the underlying configuration instead of simply following GUI-based installation steps.

I hope it serves as a practical reference for anyone working with XAMPP, Apache, MySQL, PHP, PowerShell, and WordPress.

If you have suggestions, discover improvements, or would like to contribute, feel free to open an issue or submit a pull request on GitHub.

Happy coding!

Top comments (0)