Installing the back end database server

MySQL on Windows

  1. Start installation by clicking on setup.exe in installation folder
  2. MySQL server 5.0/5.1 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"
  12. Return to MySQL configuration wizard

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

MySQL on Mac
  1. Double click on the .dmg file you downloaded in the previous step
  2. Double click on the mysql.x.pkg file
  3. Select all of the defaults and run the installer
  4. Double click on the MySQLStartupItem.pkg and run this installer. This will enable MySql to be added to your startup items so it starts automatically when the computer boots
  5. If you would like to be able to turn the MySQL server on and off from System Preferences then copy MySQL.prefPane to /Library/PreferencePanes for all users or /Users/[username] /Library/PreferencePanes for just one user

MySQL on Linux

Content to be written


Consult your Oracle DBA (database administrator) or Sysadmin.

Microsoft SQL Server

Consult your MS SQL Server DBA (database administrator) or Sysadmin.

Downloading the database server | Initializing Overview | Creating a blank database

ATInstallationGuidelinesUpdated2012.pdf1.8 MB