- 安装包下载
1) 通过https://mirrors.huaweicloud.com/mysql/Downloads/MySQL-8.0/mysql-8.0.17-winx64.zip下载压缩文件；
2) 解压到指定路径，如：D:\mysql-8.0.17-winx64。 - 配置文件
在D:\mysql-8.0.17-winx64目录下新建my.ini文件，往文件写入以下内容：
[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:\mysql-8.0.17-winx64
datadir = E:\DBs\MySQL
port = 3306
# 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
character-set-server = utf8mb4
performance_schema_max_table_instances = 600
table_definition_cache = 400
table_open_cache = 256
[mysql]
default-character-set = utf8mb4
[client]
default-character-set = utf8mb4
- 初始化数据库
从cmd（以管理员身份运行）里进入mysql解压路径下的bin目录，输入：
mysqld --initialize --console
记下打印出来第四行里随机生成的密码，方便第n步里进行密码修改。
- 安装服务
在mysql安装路径下的bin路径执行：
mysqld --install #安装完毕后接着输入下行
net start mysql
- 修改密码（可选）
还是在mysql的bin目录下执行，（随机密码有点难记，还是改成自己容易记的，以防那天忘了。。）：
mysql -u root -p #接下来会提示输入密码，输入之前记下的随机密码
# 在mysql中执行以下命令：
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourNewPassword';
运行成功后退出（exit; 或quit; 或\q;）用新密码登录mysql看是否修改成功。
