1.解压安装包

假定解压后的目录为 D:\Servers\mysql-8.0.11 ，使用命令 PowerShell 进入MySQL 解压目录

PS D:\Servers\mysql-8.0.11>

2.新建my.ini文件

[mysqld]
# innodb_buffer_pool_size = 128M
# log_bin
basedir=D:\\Servers\\mysql-8.0.11
datadir=E:\\DBData\\mysql
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
default-time-zone=+8:00
# default_authentication_plugin=mysql_native_password

3.初始化数据文件夹

PS D:\Servers\mysql-8.0.11> bin\mysqld --initialize-insecure --console

测试启动和停止服务

PS D:\Servers\mysql-8.0.11> bin\mysqld --console
PS D:\Servers\mysql-8.0.11> bin\mysqladmin -u root shutdown

4.安装 MySQL 服务（启动服务、停止服务、移除服务）

PS D:\Servers\mysql-8.0.11> bin\mysqld --install
PS D:\Servers\mysql-8.0.11> net start MySQL
PS D:\Servers\mysql-8.0.11> net stop MySQL
PS D:\Servers\mysql-8.0.11> bin\mysqld --remove

安装服务时，可指定配置文件的位置：

PS D:\Servers\mysql-8.0.11> bin\mysqld --install MySQL --defaults-file=D:\Servers\mysql-8.0.11\my.ini

测试MySQL是否安装成功：

PS D:\Servers\mysql-8.0.11> bin\mysqlshow -uroot
PS D:\Servers\mysql-8.0.11> bin\mysqlshow -uroot mysql
PS D:\Servers\mysql-8.0.11> bin\mysqladmin -uroot version status proc
PS D:\Servers\mysql-8.0.11> bin\mysql -uroot

5.修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

6.创建用户

CREATE USER 'nroot'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
GRANT ALL ON *.* TO 'nroot'@'%' WITH GRANT OPTION;