win10安装MySQL5

六、重置密码

七、允许远程登录

八、防火墙开启端口

---

一、环境准备

官网下载地址：https://downloads.mysql.com/archives/community/

mysql-5.7.22-win32.zip：https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.22-win32.zip

mysql-5.7.22-win64.zip：https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.22-winx64.zip

64位和32位安装步骤一致

二、配置文件

这里解压到 D:\MySQL 目录

my.ini 文件内容如下：

[mysqld]

port=3306

basedir=D:\MySQL\mysql-5.7.22-win32

datadir=D:\MySQL\mysql-5.7.22-win32\data

explicit_defaults_for_timestamp=true

character-set-server=utf8

default-storage-engine=INNODB

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION