A MySQL database stores information about subjects, studies, and analyses. The database needs to be set up either on a local computer, or on a server. This page contains installation and upgrade directions, and subpages below explain other actions.
Install MySQL
Before installing a new version, back up and uninstall old ones (see below). Search for mysql community server, and select to download the installer:
Select the large file and download and run:
Choose "Add" if it does not come up automatically, and select the 64-bit MySQL server, the workbench x64, and the Connector/J.
2014-10-02: Australia: The installer crashes when the date format is not US (for details see down page). To run the installer, go to Control Panel, Region, and under Location select United States, and under Format select English (United States). (See below.)
Upgrading from previous version
Sometimes prior versions can cause problems. It is best to export the database, uninstall the MySQL server and other components, and restart so the services are removed. Make a note of any MySQL users (other than root), as you may want to re-create these to ensure consistency.
Make sure you delete the MySQL data, which is the MySQL folder under C:\ProgramData\ in Windows 7. The folder is hidden, so you need to type it into the address line of Explorer.
You also need to delete the old MySQL or MySQL56 service, if it is running or present.
Command Prompt, Run As Administrator, sc delete "service name".
If the service status is "Starting" then you need to kill the process.
Command Prompt, Run As Administrator, sc "service name" to get PID; then taskkill /F /PID <the PID>
If you have trouble upgrading (there is one step where an old password is requested, which can be difficult to figure out), you should delete the MySQL data,
Crashing in Australia
When you select the product ("MySQL Server 5..21 below), the installer crashes with something about a string and datetime error.
While this will probably be fixed, as of October 20134, to work around the bug, go to Region as below (Control Panel); change the Location to United States, then the Format to English (United States). Click Apply to keep the Window open, so you can easily change it back when done.
