Wiki Spaces

Documentation
Projects
Resources

Get Help from Others

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

Documentation

Page tree

Versions Compared

Key

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

Windows 

  • Download the latest

...

  • MySQL installer using this link
  • Run the

...

  • install program (

...

  • .

...

  • msi)

...

  1. Choose 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, e.g., c:\MySQL5* or *c:\MySQL5\data. The default directory usually includes spaces, which seems to cause problems with MySQL.

...

  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 the process and give you green check marks at each stage

...

  • Accept the license agreement
  • When given the option to update installer please do so
  • Under Feature Selection select Full Installation Setup and select the right Architecture for your computer (32-bit / 64-bit)
  • Click next and you will be shown a list of applications that you need in order to meet the requirements for installing all services. Make sure you satisfy all the requirements, if not, please install the missing applications on your machine.
  • On the next configuration options select “Developer Machine”
  • Leave all other settings to default
  • Enter a username and password. Note: These will be the credentials for the user with root privileges. Do Not Forget the Password
  • Click next and finish the installation.

Note: MySQL might fail to run as a service, for this you can manually start it by navigating to Start > Settings > Control Panel > Administrative Tools > Services
Then find the service called “MySQL”, right click > Properties then you can either click the “start” button or set “Startup Type” to automatic.

Other Operating Systems

  1. Install the MySQL server package: sudo apt-get install mysql-server
  2. Enter a root password