Wiki Spaces


Get Help from Others

Q&A: Ask OpenMRS
Discussion: OpenMRS Talk
Real-Time: IRC Chat | Slack


Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  1. Download the latest stable (recommended, generally available) release of
    Wiki Markup
    {html}<A href="" mce_href="" target="_blank">MySQL</A> {html}
    --- e.g., for "Windows (x86) ZIP/Setup.EXE" ?
  2. Extract with
    Wiki Markup
    {html}<A href="" mce_href="" target="_blank">WinZip</A> {html}
  3. Run the MySQL install program (setup.exe) and 
    1. Custom Setup
    2. Change the installation directory to C:\MySQL5 and the data directory to c:\MySQL5\data\.  We recommend installing into a directory without spaces (eg. c:\MySQL5\, c:\MySQL5\data). The default directory usually includes spaces which seems to cause problems with MySQL.
  4. Accept the license agreement
  5. Accept to Configure Instance 
    1. Select "Detailed Configuration"
    2. Select "Developer Machine"
    3. Select "Multifunctional Database"
    4. InnoDB Tablespace Settings, Use the default (c: and Installation Path).
    5. Select "DSS/OLAP"
    6. Enable TCP/IP Networking (Port 3306), check "Add firewall exception..." and leave "Enable Strict Mode" checked.
    7. Default Character Set, select "Best support for Multilingualism" (utf8) 
    8. Check "Installed as Windows Service" and leave "Launch the MySQL Server automatically" checked.
    9. Root password (password) (note: do NOT forget this root password for MySQL! You will need it later)
    10. Execute the configuration, the installer should step through each step and give you green check marks at each stage
  6. If you run into problems, check the Installation Troubleshooting page or the Troubleshooting MySQL page. 
  7. Enable the MySQL port in Windows Firewall
    1. Open Windows Firewall (Start ? Settings ? Control Panel ? Windows Firewall)
    2. Under the "Exceptions" tab, click the "Add Port" button
    • Name: MySQL
    • Port number: 3306
    • (optional) for added security, click the "Change scope" button and limit to "My network (subnet) only" — this will prevent computers outside of your local area network from being able to access your database directly