Start multiple MySQL services under Windows configuration

Find the configuration to do the next record

Install mysql5.6 First, installation is not introduced

Next configure to start another MySQL service,

1: Stop the MySQL service running in the service first

2: To the MySQL installation directory (the default installation directory in C:\Program files\mysql) copy all the files under the MySQL folder to another directory (D:\MYSQL) This directory can be anywhere

3: Create MySQL config file My.ini, already existing My.ini under C:\Documents and Settings\All Users\Application Data\mysql\, copy one to D:\MYSQL and modify the name of my _3307.ini

Next Modify My_3307.ini

Port number: port=3307,

Database path

basedir= "D:/mysql/mysql Server 5.6/"

Datadir= "D:/mysql/mysql Server 5.6/data"

4: Create a startup service

Mysqld Install MySQL3307--defaults-file= "D:\MySql\my_3307.ini"

6: Modify the Registry

Hkey_local_machine-->system-->currentcontrolset-->services

Change the ImagePath under MySQL3307 to "D:\MySql\MySQL Server 5.6\bin\mysqld.exe"--defaults-file=d:\mysql\my_3307.ini MySQL3307

Configuration is complete and all MySQL services can be started in the service.

Start multiple MySQL services under Windows configuration