Tag Archives: Windows tools

Install Apache, PHP, MySQL & PHPMyAdmin on Windows 7

Installing Apache, PHP, MySQL and PHPMyAdmin on Windows 7 (64 bit).

Apache (more properly Apache HTTP Server) is a web server.

PHP is a programming language that can be used within a web document and which is processed before the document is served up by the web server (Apache here).

MySQL is a database server.

PHPMyAdmin is a graphical interface for administering MySQL databases using a web browser. It is written in PHP, and so the interaction with the MySQL database server takes place via web documents served up by Apache.

The easiest way is simply to install them all bundled together as WampServer. The version I am using includes:

  • Apache 2.2.21
  • Php 5.3.8
  • Mysql 5.5.16
  • PhpMyadmin 3.4.5
  • …and various other utilities.

  1. Download the executable from the WampServer downloads page. I have selected the 64-bit version. I believe that only MySQL has a distinct 64-bit version. Because I want to enable MySQL support for Qt SDK, I need to use 32-bit MySQL.
  2. Run the executable (double-click on the file icon).
  3. Accept all defaults, and permit all requests. Accept all offers of taskbar and desktop links. This worked fine for me, installing the WampServer files in c:\wamp\.
  4. See that the installation is working correctly by opening the web browser and navigating to http://localhost/index.php.
  5. Run PHPMyAdmin by navigating to http://localhost/phpmyadmin/.
  6. PHPMyAdmin may display a warning inviting you to set a password for the root user. If you set a password via PHPMyAdmin (“Privileges” tab), you will need to modify the PHPMyAdmin configuration file. Mine is at c:\wamp\apps\phpmyadmin3.4.5\config.inc.php. Search for the line $cfg['Servers'][$i]['password'] = ''; and modify it to $cfg['Servers'][$i]['password'] = '******';, replacing the asterisks with your root password.
  7. Each time you reboot the machine, restart WampServer manually using Start > All Programs > WampServer > start WampServer.