Windows10系统,MySQL8.x zip安装

下载

https://dev.mysql.com/downloads/mysql/
在这里插入图片描述

配置

在Windows系统中,配置文件默认是安装目录下的 my.ini 文件,部分配置需要在初始安装时配置,大部分也可以在安装完成后进行更改。当然,极端情况下,所有的都是可以更改的。

在安装根目录下添加 my.ini,比如我这里是:D:\app\mysql-8.0.19-winx64\my.ini,写入基本配置:

[mysqld]
port=3306
basedir=D:\app\mysql-8.0.23-winx64
datadir=D:\app\mysql-8.0.23-winx64\data

performance_schema_max_table_instances=600
table_definition_cache=400
table_open_cache=256

character-set-server=utf8mb4

default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

[mysql]
default-character-set=utf8mb4

[client]
port=3306
default-character-set=utf8mb4

初始化数据库

在MySQL安装目录的 bin 目录下执行命令:

.\mysqld.exe --initialize --console

最后那段是root默认密码 Ax=pg,j5;sQh

PS D:\app\mysql-8.0.23-winx64\bin> .\mysqld.exe --initialize --console
2021-04-02T05:43:52.288333Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-04-02T05:43:52.288539Z 0 [System] [MY-013169] [Server] D:\app\mysql-8.0.23-winx64\bin\mysqld.exe (mysqld 8.0.23) initializing of server in progress as process 23272
2021-04-02T05:43:52.297386Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-02T05:43:59.384965Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-04-02T05:44:14.782957Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Ax=pg,j5;sQh

安装服务

.\mysqld.exe --install [服务名]

卸载服务

.\mysqld.exe -remove mysql8

启动服务

PS D:\app\mysql-8.0.23-winx64\bin> net start mysql8
mysql8 服务正在启动 ..
mysql8 服务已经启动成功。

使用

在这里插入图片描述