window to create a MySQL multi-instance

Download Open source MySQL, depending on the version of the selected response

https://dev.mysql.com/downloads/mysql/

Installation

If you encounter the following error

Installation Error MSVCP120.dll and MSVCR120.dll

installation vcredist_13x64

Configuration database files

Vim My.ini

[MySQL]

Default-character-set=utf8

[Mysqld]

Port = 3306

Basedir=d:\mysql-5.7.18-winx64

Datadir=d:\mysql-5.7.18-winx64\data

max_connections=200

Character-set-server=utf8

Default-storage-engine=innodb

Register, start the database

mysqld install MySQL--defaults-file= "D:\mysql-5.7.18-winx64\my.ini"

Mysqld--initialize

net start MySQL

Check 3306 port, link test

Instance N

Copy the above MySQL folder to a different location

Change My.ini Internal, three file configurations

Port = 3307

Basedir=e:\mysql-5.7.18-winx64

Datadir=e:\mysql-5.7.18-winx64\data

Mysqld Install mysql_test --defaults-file= "E:\mysql-5.7.18-winx64\my.ini"

Mysqld--initialize

To change the registration form

Modify Hkey_local_machine-->system-->currentcontrolset-->services Find the mysql_test you just created, and change the ImagePath to the following ":" E:\ Mysql-5.7.18-winx64\bin\mysqld "--defaults-file=" E:\mysql-5.7.18-winx64\my.ini "mysql_testnet start mysql_test

Check Port 3307

window to create a MySQL multi-instance