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.
Install the MySQL server package as root:
Docker allows easy installation of MySQL in a self-contained container on linux but is a bit more complicated option on Windows or OSX. See https://docs.docker.com/engine/installation/ on how to start using Docker.
After you have installed Docker, it's easy to launch a MySQL container. This will download a MySQL 5.6 Docker image and run it:
Now you can connect to the database on port 3306 with username "root" and password "openmrs". Note that the port mapping argument
-p 3306:3306 is needed to expose MySQL service's port inside the container to the host.
You may also ask Docker to list all Docker containers:
Need to test on another MySQL version? You may run multiple MySQL container's simultaneously just as long as you give them unique names and port mappings. For example to run a MySQL 5.5 container, you might say:
Stopping and starting your database container is easy:
If you decide you don't need the database any more you can remove it:
Note: Some people may have trouble with different MySQL versions. Although higher versions of MySQL should work fine with OpenMRS, if you encounter problems with later versions of MySQL, try downgrading to version 5.6 as that is the recommended version.