Shulou(Shulou.com)06/03 Report--

Let's learn about the method of creating multi-instance of window system mysql. I believe you will benefit a lot after reading it. The text is not much in essence. I hope this short article of window system mysql multi-instance creation method is what you want.

Download the open source mysql and select the version of the response according to the download address

Https://dev.mysql.com/downloads/mysql/

Installation

If you encounter the following error report

Install error MSVCP120.dll and MSVCR120.dll

Install vcredist_13x64

Configure 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 port 3306, link test

Instance N

Copy the mysql folder above to another place

Change the configuration of three files inside my.ini

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

Change the registry

Modify HKEY_LOCAL_MACHINE-- > SYSTEM-- > CurrentControlSet-- > Services to find the mysql_test you just created, and modify the ImagePath as follows: "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

After reading this article on how to create multiple instances of window system mysql, many readers will want to know more about it. If you need more industry information, you can follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.