Installing MySQL

Download the MySQL server and MySQL Administrator from http://www.mysql.com/downloads (Click on ‘download’ under ‘MySQL Community Server’ - free download)

Installing the MySQL (Windows) backend database:

1. Start installation by clicking on setup.exe in installation folder
2. MySQL server 5.x setup wizard is launched
3. Select "Complete" install and then select "Next"
4. Click "Install"
5. Select "Skip Sign-up" (or not) and click on "Next"
6. Make sure the checkbox for "Configure the MySQL Server now" is checked
7. Click on "Finish"
8. It returns the MySQL Server Instance Configuration Wizard
9. Click on "Next"
10. Select option for "Detailed Configuration" and click on "Next"
11. Select option for "Developer Machine" and click on "Next"
12. Select option for "Multifunctional Database" and click on "Next"
13. Accept Default Drive and Path settings and click on "Next"
14. Select "Decision Support (DSS)/OLAP and click on "Next"
15. Accept selection of "Enable TCP/IP Networking," Port number = "3306", and "Enable Strict Mode" and click on "Next"
16. Select "Best Support of Multilingualism" (supports the UTF8 character set used by AT) and click on "Next"
17. Select "Install as Windows Service" and "Include Bin Directory in Windows PATH" and click on "Next"
18. Select "Modify Security Settings" and enter and confirm a "Root" password. Make note of this password, as it will be needed to enter the MySQL command editor
19. If installing in a network environment, select "Enable root access from remote machine." Otherwise, leave it unselected
20. Click on "Next"
21. Click on "Execute"

If you receive a "Connection Error" because a firewall is prohibiting access to port 3306, you will have to change the settings [else, skip to step 3]:

1. Open the Control Panel
2. Open Windows Firewall
3. Click on Exceptions tab
4. Review list of programs and services to make sure MySQL does not appear
5. Click on "Add Port" button
6. Enter "MySQL" as name
7. Enter "3306" as Port number
8. Accept selection of TCP
9. Click on "OK"
10. Review list of programs and services to make sure MySQL now appears there
11. Click on "OK"

Return to MySQL configuration wizard

12. Click on "Retry" on "Connection Error" dialogue
13. Click on "Finish"