Wiki Spaces

Documentation
Projects
Resources

Get Help from Others

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

Documentation

Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Home           Previous Page           Next Page

  1. Download the latest stable (recommended, generally available) release of MySQL--- e.g., for "Windows (x86) ZIP/Setup.EXE" ? mysql-5.0.41-win32.zip
  2. Extract with WinZip
  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 here















    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
  • No labels