Create a PHP, MySQL and Apache development environment_MySQL

Apache

In this tutorial we’ll install PHP, MySQL and Apache locally.

Create a PHP, MySQL and Apache development environment

In my experience the easiest method to install PHP, MySQL and Apache for a local Windows platform is with one of the Bitname stacks (for Mac users:tutorial how to install Apache, PHP and MySQL on a Mac).

1. Download and run WAMP stack

Visit the Bitnami site and downloadthe WAMP stack installer.

Double-click on the download package to start the installaton.

2. Additional components?

We only need to install phpMyAdmin. When asked which components you want to install you can uncheck all except the last (phpMyAdmin).

Next you’ll be asked to select a folder for the installation. Do not install inside the Windows Programs folder because then you will not be allowed to edit any files inside this folder. And you definitely will want to edit files in this development environment.

Then you’ll be asked if you want to learn more about cloud hosting. You can uncheck this because we’ll install WAMP on your local machine.

3. Create MySQL ‘root’ account

Remember the password you insert during this step. Later on you will need it to log in to phpMyAdmin with ‘root’ as user and the password you insert during this step.

Afterwards you can add other users in phpMyAdmin. However – to create databases and tables – you will need to log in as the ‘root’ user because other users do not have that privilege.

When you finish the installation the WAMP stack will start the MySQL Database and the Apache web Server. You’ll get a Welcome screen. Click on the tab ‘Manage Servers’ to check if both are running.

To open phpMyAdmin go to the Welcome tab and click on the button ‘Open phpMyAdmin’. This will open the login screen where you need to insert ‘root’ and your password. We will look into what you can do with phpMyAdmin in another tutorial.

Start the WAMP stack

On the next occasion when you want to work with your local development environment locate the Bitnami WAMP stack between the other programs on your machine.

Then click on ‘wampstack manager tool’.

The working directory (where you need to insert your PHP scripts) will beyourfolder/apache2/htdocs (e.g. “C:/Bitnami/wampstack-version.no/apache2/htdocs/”).