2.2.1 Prerequisite: MySQL

Installing MySQL

1. Download the Installer
2. Launch Installer
3. Check 'Configure MySQL Server Now'
4. Check 'Standard Configuration'
5. Install Windows Service/Launch Automatically
6. Modify Security Settings
7. Execute
8. Grant All Privileges to ROOT

1. Download the Installer

Download MySQL 5.1+, GA (Generally Available) installer for Windows at http://dev.mysql.com/downloads/mysql/. 

2. Launch Installer

Launch the MySQL installer and select "Typical Install", clicking next until you are given the option to check the checkbox for "Configure MySQL Server Now".

3. Check 'Configure MySQL Server Now'

Make sure the "Configure MySQL Server Now" is checked, and click next to get to the "MySQL Server Instance Configuration" dialog.

4. Check 'Standard Configuration'

Check the "Standard" configuration and click Next.

5. Install Windows Service/Launch Automatically

Ensure that it is installing as a "Windows Service" and that "Launch the MySQL Server Automatically" is checked. Click Next.

6. Modify Security Settings

Check "Modify Security Settings", and enter a root MySQL password and ensure that the checkbox allowing root to "connect from network" is checked.

7. Execute

Click "Execute" and then click "Finish".

8. Grant all privileges to ROOT

 Before connecting to MySQL you will need to GRANT access to your user and machine. Because the MySQL JDBC driver uses TCP/IP sockets instead of Unix Domain Sockets, the security manager in MySQL server will use the HOSTS table to determine whether or not the connection should be allowed. To grant your user access use this syntax: "GRANT ALL PRIVILEGES ON [dbname].* to ’[user]’@’[hostname]’ identified by ’[password]’" to generate and execute an SQL command.

mysql -u root -p <press enter and it will ask for mysql root password>
        -mysql> GRANT ALL PRIVILEGES on *.* to `root`@'%' identified by '(type in the root password)' with grant option; <press enter>
        -mysql> exit; <press enter>

NOTE: It is important that the MySQL configuration have its bind-address set to the IP address of the computer it is installed on, within the my.ini file. See this link  http://dev.mysql.com/doc/refman/5.1/en/option-files.html for location of the configuration file and the order that MySQL reads the configuration information.