windows下安装多个mysql5.7.16免安装版版本数据库

一：安装mysql5.7.16

1)解压mysql-5.7.16-winx64到指定文件夹下 ，路径为：E:\jee\mysql-5.7.16-winx64

2）拷贝my-default.ini，改名为my.ini

3）创建数据文件夹data到指定目录（一般情况下选择在mysql5.7.16文件夹下创建data文件夹）

4）在my.ini文件夹中添加mysql文件夹目录，数据文件目录，指定端口等。修改后全文件内容如下：

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

# 以下内容手动添加
[client]
port=3306
default-character-set=utf8
[mysqld]
port=3306
character_set_server=utf8
#解压目录
basedir=E:\jee\mysql-5.7.16-winx64
#解压目录下data目录
datadir=E:\jee\mysql-5.7.16-winx64\data

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
E:\jee\mysql-5.7.16-winx64\bin\mysqld.exe

5）在环境变量中添加mysql启动路径：E:\jee\mysql-5.7.16-winx64\bin

6）右键cmd.exe,选择以管理员身份运行cmd.exe

7) 在dos窗口中执行如下命令，将mysql添加到windows服务中，方便日后手动启动、停止mysql。

mysqld --install MYSQL

8)在dos窗口中执行如下命令，创建数据库文件

mysqld --initialize-insecure --user=mysql

9）启动数据库，执行如下命令

net start mysql

10)关闭数据库，执行如下命令

net stop mysql

11)移除服务名，执行如下命令

mysqld --remove mysql

二、安装第二个myql数据库

1）拷贝源数据库文件夹，并更名，如：mysql5.7.15。路径为E:\jee\mysql-5.7.15-winx64

2）手动清空data目录，重新创建数据库（不执行此步骤，会造成数据库无法安装，启动等问题）

3）修改my.ini文件中mysql文件夹目录，数据文件目录，指定端口等。修改后全文件内容如下：

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

# 以下内容手动添加
[client]
port=3307
default-character-set=utf8
[mysqld]
port=3307
character_set_server=utf8
#解压目录
basedir=E:\jee\mysql-5.7.15-winx64
#解压目录下data目录
datadir=E:\jee\mysql-5.7.15-winx64\data

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
E:\jee\mysql-5.7.15-winx64\bin\mysqld.exe

4）在环境变量中添加mysql启动路径：E:\jee\mysql-5.7.15-winx64\bin

5）右键cmd.exe,选择以管理员身份运行cmd.exe

6) 在dos窗口中执行如下命令，将mysql添加到windows服务中，方便日后手动启动、停止mysql。

mysqld --install MYSQL2 --defaults-file="E:\jee\mysql-5.7.15-winx64\bin\my.ini"

备注：此时需要添加--defaults-file参数，否则由于环境变量问题启动报错

7）打开注册表，找到HKEY_LOCAL_MACHINE\SYSTEM\services\MYSQL2,修改ImagePath参数，更正mysql服务相关路径。修改后内容如下：

E:\jee\mysql-5.7.15-winx64\bin\mysqld --defaults-file=E:\jee\mysql-5.7.15-winx64\\my.ini MySQL2

8)在dos窗口，进入到bin目(即：E:\jee\mysql-5.7.15-winx64\bin)录后，执行如下命令，创建数据库文件

mysqld --initialize-insecure --user=mysql

9）启动数据库，执行如下命令

net start mysql2

10)关闭数据库，执行如下命令

net stop mysql 2

11)移除服务名，执行如下命令

mysqld --remove mysql2