Mysql免安装版安装步骤

1. Mysql官网社区版 下载Mysql免安装版；

2.解压到指定文件夹；

3.复制my-small.ini，重命名为mysql.ini;

4.在[mysqld]下添加 配置（具体以自己的解压目录为准）：

# 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.

[mysql]
#设置以下配置相当于同时设置了character_set_client(客户端)、character_set_connection(连接)、character_set_result(返回结果)的字符集均为utf8
default_character_set=utf8mb4

#设置客户端连接的校对规则（排序规则）
#collation_connection=utf8mb4_bin

[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 = "D:/software/mysql-5.6.46-winx64"
datadir = "D:/software/mysql-5.6.46-winx64/data"
port = 3310
# server_id = .....

#设置默认时区为东八区
default_time_zone='+8:00'

#设置服务器级别的字符编码使用utf8mb4，如不单独设置数据库级别、表级别、字段级别的字符集，则默认都使用服务器级别的字符编码
#建议使用utf8mb4代替之前的utf8，utf8mb4是4个字节的unicode编码，而utf8最多使用3个字节的unicode编码，并不是真正的UTF-8编码，
#会导致部分特殊的字符无法插入
character_set_server=utf8mb4

#设置字符集的校对规则（排序规则）为大小写敏感的，不然会导致某些敏感数据不区分大小写，导致业务上出问题
collation_server=utf8mb4_bin

#修改 发送给服务器的最大数据包大小
max_allowed_packet=20M
#设置表明不区分大小写(windows下默认都是不区分的,如果配置了会启动失败，linux下的话需要设置，不然容易出现表不存在的错误，特别是使用quatz等自动生成表的框架，有可能生成的表示大写的，代码或者sql使用小写的去查询就会报错)
#lower_case_table_names=0 

# 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 

#解决mysql启动报timestamp的警告问题，关闭timestamp的默认，如需要DEFAULT CURRENT_TIMESTAMP和ON UPDATE，需显示指定默认值为timestamp类型的字段
explicit_defaults_for_timestamp=true

init_connect="set collation_connection=utf8mb4_bin"

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

5.打开C:\Windows\System32 目录，以管理员运行cmd.exe,执行D:\software\Mysql\mysql-5.5.62-winx64\bin\mysqld install(以自己解压目录为准)，安装,MySQL服务;

6.服务安装成功，启动服务：net start MySQL(停止服务为：net stop MySQL)；

7.将bin目录添加到path以方便使用命令行；

8.MySQL安装成功！！！

 

后续自己配置密码和开启允许远程访问等