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 服务已经启动成功。
使用
本博客所有文章除特别声明外,均采用 CC BY-SA 4.0 协议 ,转载请注明出处!