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.

Home           Previous Page           Next Page

  1. Download the latest stable (recommended, generally available) release of
    Wiki Markup
    {html}<A href="http://


  1. dev.




  1. Download the latest stable (recommended, generally available) release of
    Wiki Markup
    {html}<A /downloads/mysql/5.0.html#win32" 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 run Custom Setup. Accept all defaults except the installation directory and the data directory, 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 ? Select "Detailed Configuration" ? Developer Machine ? Multifunctional Database ? InnoDB Settings (c: and Installation Path) ? DSS/OLAP ? Enable TCP/IP Networking (Port 3306) ? Select "Manual Selected Default Character Set / Collation" and set the character set to utf8 ? Check "Installed as Windows Service" ? Root password (password) (note: do NOT forget this root password for MySQL! You will need it later)
  6. Execute the configuration, the installer should step through each step and give you green check marks at each stage
  7. If you are stopped with a message saying that the server could not be started, your Windows Firewall may be blocking the MySQL port (default port is 3306). For problems related to error 1067 check the MySQL forum
    Wiki Markup
    {html}<A href=",11388,11388" mce_href=",11388,11388" target="_blank">here</A><BR mce_bogus="1"></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR><BR></BR>{html}
    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