Friday, November 2, 2012

WAMP Step 3: Install MySQL

In the previous installments of this series (here and here), we set up and configured the Apache web server and the PHP scripting engine. Now we will add the database server, MySQL.

SQL databases implement the powerful relational database paradigm, a way of thinking about data that is based in the mathematics of set theory. This makes them (in theory) more powerful and safer than other kinds of databases that preceded them. While relational databases started life on mainframes, MySQL is an example of how the concept can be adapted to desktops. After all, your desktop is probably a more powerful computer than the 'big iron' mainframe of the 1960's!

Installing MySQL

MySQL started as the project of an independent company, which was subsequently acquired by Oracle. A free and open version is still available, called the "community" server.

The MySQL download for the Community Server is at If you just got, you'll be offered a Windows installer that includes a whole bunch of additional software and connectors, over 200 MB of stuff! We don't need all of that to test out WordPress, which is the objective of this exercise. Just grab the installer for the Community Server.

Click on the .msi file once it is downloaded and begin the install.
Click "Run".
Click "Next"
Select “Typical”. Click “Next”.
Click “Install”. Click “Next”.
Click “Next”.Select “Configure the MySQL Server now”. Click “Finish”.

The installation will segue directly into the MySQL configuration process.

A Configuration Wizard will appear. Click “Next”.
Select “Detailed Configuration”. Click “Next”.
Select “Developer Machine”. Click “Next”.
Select “Multifunctional Database”. Click “Next”.
Select “C:” drive and “Installation Path”. Click “Next”.
Select “Decision Support (DSS)/OLAP”. Click “Next”.
Select “Enable TCP/IP Networking”. Set Port Number to: 3306. Select “Enable Strict Mode”. Click “Next”.
Select “Standard Character Set”. Click “Next”.
Select “Install As Windows Service”. Select “Launch the MySQL Server automatically”.  Select “Include Bin Directory in Windows PATH”. Click “Next”.
Enter the new root password (twice): “example”. Click “Next”.
Click “Execute”.
Click “Finish”.

No comments: