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 

  1. Download the latest stable (recommended,

...

  1. generally

...

  1. available)

...

  1. release

...

  1. of

...

  1. MySQL
  2. Extract with an unzip tool such as WinZip
  3. Run the MySQL install program (setup.exe)

...

  1. and

...

    1. Custom

...

    1. Setup

...

    1. Change

...

    1. the

...

    1. installation

...

    1. directory

...

    1. to

...

    1. C:\MySQL5

...

    1. and

...

    1. the

...

    1. data

...

    1. directory

...

    1. to

...

    1. c:\MySQL5\data\.

...

    1. We

...

    1. recommend

...

    1. installing

...

    1. into

...

    1. a

...

    1. directory

...

    1. without

...

    1. spaces,

...

    1. e.g.,

...

    1. c:\MySQL5

...

    1. *

...

    1. or

...

    1. *c:\MySQL5\data

...

    1. .

...

    1. The

...

    1. default

...

    1. directory

...

    1. usually

...

    1. includes

...

    1. spaces

...

    1. which

...

    1. seems

...

    1. to

...

    1. cause

...

    1. problems

...

    1. with

...

    1. MySQL.

...

  1. Accept

...

  1. the

...

  1. license

...

  1. agreement

...

  1. Accept

...

  1. to

...

  1. Configure

...

  1. Instance

...

    1. Select

...

    1. "Detailed

...

    1. Configuration"

...

    1. Select

...

    1. "Developer

...

    1. Machine"

...

    1. Select

...

    1. "Multifunctional

...

    1. Database"

...

    1. InnoDB

...

    1. Tablespace

...

    1. Settings,

...

    1. Use

...

    1. the

...

    1. default

...

    1. (c:

...

    1. and

...

    1. Installation

...

    1. Path).

...

    1. Select

...

    1. "DSS/OLAP"

...

    1. Enable

...

    1. TCP/IP

...

    1. Networking

...

    1. (Port

...

    1. 3306),

...

    1. check

...

    1. "Add

...

    1. firewall

...

    1. exception..."

...

    1. and

...

    1. leave

...

    1. "Enable

...

    1. Strict

...

    1. Mode"

...

    1. checked.

...

    1. Default

...

    1. Character

...

    1. Set,

...

    1. select

...

    1. "Best

...

    1. support

...

    1. for

...

    1. Multilingualism"

...

    1. (utf8)

...

    1. Check

...

    1. "Installed

...

    1. as

...

    1. Windows

...

    1. Service"

...

    1. and

...

    1. leave

...

    1. "Launch

...

    1. the

...

    1. MySQL

...

    1. Server

...

    1. automatically"

...

    1. checked.

...

    1. Root

...

    1. password

...

    1. (password)

...

    1. (Note:

...

    1. Do

...

    1. NOT

...

    1. forget

...

    1. this

...

    1. root

...

    1. password

...

    1. for

...

    1. MySQL

...

    1. !

...

    1. You

...

    1. will

...

    1. need

...

    1. it

...

    1. later.)

...

    1. Execute

...

    1. the

...

    1. configuration,

...

    1. the

...

    1. installer

...

    1. should

...

    1. step

...

    1. through

...

    1. each

...

    1. step

...

    1. and

...

    1. give

...

    1. you

...

    1. green

...

    1. check

...

    1. marks

...

    1. at

...

    1. each

...

    1. stage

...

  1. If

...

  1. you

...

  1. run

...

  1. into

...

  1. problems,

...

  1. check

...

  1. the

...

  1. Installation

...

  1. Troubleshooting

...

  1. page

...

  1. or

...

  1. the

...

  1. Troubleshooting

...

  1. MySQL

...

  1. page.

...

  1. Enable

...

  1. the

...

  1. MySQL

...

  1. port

...

  1. in

...

  1. Windows

...

  1. Firewall

...

    1. Open

...

    1. Windows

...

    1. Firewall

...

    1. (Start

...

    1. ?

...

    1. Settings

...

    1. ?

...

    1. Control

...

    1. Panel

...

    1. ?

...

    1. Windows

...

    1. Firewall)

...

    1. Under

...

    1. the

...

    1. "Exceptions"

...

    1. tab,

...

    1. click

...

    1. the

...

    1. "Add

...

    1. Port"

...

    1. button

...

    1. Name:

...

    1. MySQL
    2. Port number:

...

    1. 3306
    2. Optional:

...

    1. For

...

    1. added

...

    1. security,

...

    1. click

...

    1. the

...

    1. "Change

...

    1. scope"

...

    1. button

...

    1. and

...

    1. limit

...

    1. to

...

    1. "My

...

    1. network

...

    1. (subnet)

...

    1. only".

...

    1. This

...

    1. will

...

    1. prevent

...

    1. computers

...

    1. outside

...

    1. of

...

    1. your

...

    1. local

...

    1. area

...

    1. network

...

    1. from

...

    1. being

...

    1. able

...

    1. to

...

    1. access

...

    1. your

...

    1. database

...

    1. directly.

...

Other

...

Operating

...

Systems

...

  1. Install

...

  1. the

...

  1. MySQL

...

  1. server

...

  1. package:

...

  1. sudo

...

  1. apt-get

...

  1. install

...

  1. mysql-server

...

  1. Enter

...

  1. a

...

  1. root

...

  1. password