The user is allowed to run multiple MySQL instances on a single Windows machine either by using the command line and passing values or by the window service.
- Starting multiple MySQL instances at the Windows command line: To execute multiple instances using the command line, we can either specify the option at runtime or we can set it in the option file. The option file is a better option to start instances because there is no need to specify arguments every time at startup. To setup or configure the option file, follow the same steps described in Chapter 2, Installing and Upgrading MySQL.
- Starting multiple MySQL instances as Windows services: To start multiple instance on Windows as service, we ...