jim.bernatowicz

XAMPP is a good packaging of a full WAMP (Windows, Apache, mysql, PHP) stack.

This tutorial will walk you though setting up a complete development environment on Windows. I am using Windows 7 Home Premium, 64-bit. This setup also works well on Windows XP, and I have heard this also works on Vista, although I have never run Vista myself.

In the end we will have the following installed:

1. Apache Web Server
2. PHP for server-side processing
3. mysql database server
4. phpmyadmin for managing mysql databases via a web browser
5. SVN Server for source code version control

In XAMPP 1.7.3 mysql is installed with a blank root password. This article provides some guidance to setting a non-blank root password in XAMPP for Windows. It will change the password on the mysql server as well as the phpmyadmin client admin module.

There are two methods for setting the root password, and a tip on disabling anonymous access to phpmyadmin.

http://www.apachefriends.org/en/faq-xampp-windows.html#password1

-- phpMyAdmin SQL Dump
-- version 2.11.3deb1ubuntu1
-- http:// www.phpmyadmin.net
--
-- Host: www.photips.com
-- Generation Time: Jun 03, 2008 at 08:44 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.4-2ubuntu5.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `acl`
--

-- --------------------------------------------------------

--
-- Table structure for table `ACL_CLASS`
--

CREATE TABLE IF NOT EXISTS `ACL_CLASS` (
  `ID` bigint(20) NOT NULL auto_increment,
  `CLASS` varchar(100) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `UNIQUE_UK_2` (`CLASS`)