windows下 MySQL手动安装与卸载

下载文件以后进行解压 ，指定文件的具体位置

1、安装

选择路径下的mysqld --intall 指定服务名称  --设置配置文件

例子： C:\Users\Administrator\Desktop\mysql\mysql\bin\mysqld --install "MYSQL3" --defaults-file="C:\Users\Administrator\Desktop\mysql\mysql\my.ini"  安装

my.ini配置

————————————————————————————————————————————————————————

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/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]
basedir=C:\Users\Administrator\Desktop\mysql-5.6.24-winx64\mysql-5.6.24-winx64
datadir=C:\Users\Administrator\Desktop\mysql-5.6.24-winx64\mysql-5.6.24-winx64\data
port =3308
# 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

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

————————————————————————————————————————————————————————

启动MySQL服务：

2、卸载

停止MySQL服务

选择路径下的mysqld --remove 指定服务名称  --设置配置文件
例子： C:\Users\Administrator\Desktop\mysql\mysql\bin\mysqld --remove "MYSQL3" --defaults-file="C:\Users\Administrator\Desktop\mysql\mysql\my.ini"   卸载