P01 MySQL 8.0.30 安装

小灰灰 2024-04-06 10:59 6阅读 0赞

#### P01 MySQL 8.0.30 安装 ####

*  1.下载软件
 *  2.开始安装
 *   *  2.1 Choosing a Setup Type
     *  2.2 Select Products
     *  2.3 Check Requirements
     *  2.4 Installation
     *  2.5 Product Configuration
     *   *  2.5.1 Type and Networking
         *  2.5.2 Authentication Method
         *  2.5.3 Accounts and Roles
         *  2.5.4 Windows Service
         *  2.5.5 Apply Configuration
     *  2.6 Installation Complete
 *  3.参数修改

> 系统：Win10  
> Java：1.8.0\_333  
> IDEA：2020.3.4  
> MySQL：8.0.30  
> Gitee：[https://gitee.com/lijinjiang01/JavaWeb][https_gitee.com_lijinjiang01_JavaWeb]

## 1.下载软件 ##

进入MySQL官网：[**https://www.mysql.com/**][https_www.mysql.com]，转到最下面，点击 MySQL Community Server  
![在这里插入图片描述][3ada5351785c4ec3a426dc7bbf4846d8.png]

点击 **Go to Download Page** 前往 MSI 格式下载页面  
![在这里插入图片描述][9343a0a80a7245e2bb5b02f036d0a595.png]

点击大的下载  
![在这里插入图片描述][b6bf18226f4e4d14aa469475bdc3ed15.png]

点这里直接下载  
![在这里插入图片描述][ce7443deca6f4c5b923881efdcf552ef.png]

等待下载结束即可  
![在这里插入图片描述][9ad5b91ec8344fc8b688a1ceef5e29f1.png]

## 2.开始安装 ##

双击下载好的安装包开始进行安装  
![在这里插入图片描述][dd0f06a3efe84c358d724b02ecd4dfdd.png]

### 2.1 Choosing a Setup Type ###

安装类型选择这个 **Custom**（自定义），然后继续  
![在这里插入图片描述][6e8bd0e6dedf49428f72179c42d45e14.png]

### 2.2 Select Products ###

安装产品添加 **MySQL Server** 和 **Connector/J**（Java开发需求，别的开发语言选对应的），然后继续  
![在这里插入图片描述][6b9636ec48c24c2dacdb0b4ebd731074.png]

### 2.3 Check Requirements ###

检查安装MySQL所需要的东西，点击执行即可  
![在这里插入图片描述][1189eb75d71b4b31b8019cfbf44fa45b.png]

同意安装插件然后安装，安装成功关闭这个小弹窗  
![在这里插入图片描述][11f5659aae024dcca057006874512459.png]

安装结束点击继续  
![在这里插入图片描述][c1373fcf03ec4ed080bff2aefe1f30ca.png]

### 2.4 Installation ###

点击执行安装  
![在这里插入图片描述][da41b55da0ea4677b972181f29d6f084.png]

点击继续  
![在这里插入图片描述][861b100b97914afaaec54c6d6f98328e.png]

### 2.5 Product Configuration ###

点击继续  
![在这里插入图片描述][297013962be841369c6359117d7a6cf4.png]

#### 2.5.1 Type and Networking ####

默认配置，点击继续  
![在这里插入图片描述][3e4ae8557b1c4d99873cb1fc57879851.png]

#### 2.5.2 Authentication Method ####

选择下面这个（否则 Navicat 不好连接 MySQL），然后继续  
![在这里插入图片描述][53a66162f40d4281ae6bf30bf13035aa.png]

#### 2.5.3 Accounts and Roles ####

设置默认密码，点击继续  
![在这里插入图片描述][1d393b9e29ff4fbbbf9f19ed6e8e0e2e.png]

#### 2.5.4 Windows Service ####

默认设置，点击继续  
![在这里插入图片描述][1d068331ded14297baf15dfbc635ce5f.png]

#### 2.5.5 Apply Configuration ####

点击执行  
![在这里插入图片描述][a281d9adc6164d9fa8888f49ccbbf2de.png]

执行结束，点击结束按钮  
![在这里插入图片描述][41eeb99e8700461d9579d8ca7e6077b3.png]

点击下一步  
![在这里插入图片描述][f703d91fe6604a18b6b1ba92cffafe8c.png]

### 2.6 Installation Complete ###

点击结束，完成安装  
![在这里插入图片描述][2e13f90485524da29e46a3e49345bfb6.png]

## 3.参数修改 ##

在目录：C:\\ProgramData\\MySQL\\MySQL Server 8.0 下找到 my.ini，右键编辑，添加如下配置信息

# 设置默认时区
    default-time_zone='+8:00'
    # 设置日志时间
    log_timestamps=system

[https_gitee.com_lijinjiang01_JavaWeb]: https://gitee.com/lijinjiang01/JavaWeb
[https_www.mysql.com]: https://www.mysql.com/
[3ada5351785c4ec3a426dc7bbf4846d8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/cfce5439bc514cd9a666a9502d6b5faf.png
[9343a0a80a7245e2bb5b02f036d0a595.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/4119c293a6d94649bdef01f01ba401aa.png
[b6bf18226f4e4d14aa469475bdc3ed15.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/ba42fca62764458297ecc2ef5f8369a8.png
[ce7443deca6f4c5b923881efdcf552ef.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/47f66e391cfb4d9284c95cc145fb49cf.png
[9ad5b91ec8344fc8b688a1ceef5e29f1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/ac1c06f476af4137a3e7c9b564b61d0b.png
[dd0f06a3efe84c358d724b02ecd4dfdd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/304f8e3277994a878f5ae09fb5832dec.png
[6e8bd0e6dedf49428f72179c42d45e14.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/f713df4397c54677bee64b4d1c7a64da.png
[6b9636ec48c24c2dacdb0b4ebd731074.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/99de9180b2a74deeb9e241fc4b372c65.png
[1189eb75d71b4b31b8019cfbf44fa45b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/6271bd4a6f144b0d9720398633585bcb.png
[11f5659aae024dcca057006874512459.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/e7cd368a522d46b9a222e2086d9af76b.png
[c1373fcf03ec4ed080bff2aefe1f30ca.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/02736f63286a4c20b22f0d04b2bfa02b.png
[da41b55da0ea4677b972181f29d6f084.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/7c3cfc662dbd4d629c25e2695b6dd1e7.png
[861b100b97914afaaec54c6d6f98328e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/c9c32d7b86f34df096f8d3aa86e16cd9.png
[297013962be841369c6359117d7a6cf4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/802d15daa2474ead839b9646bd656889.png
[3e4ae8557b1c4d99873cb1fc57879851.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/ac5fcf8155d44a10b8a14e436db45532.png
[53a66162f40d4281ae6bf30bf13035aa.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/02a8dc3ae4874db99e289fd9b8288103.png
[1d393b9e29ff4fbbbf9f19ed6e8e0e2e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/6593eef954b54ed09ad052f9b4a2480e.png
[1d068331ded14297baf15dfbc635ce5f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/0eeaf6a940804966869a6ede06f5ff8c.png
[a281d9adc6164d9fa8888f49ccbbf2de.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/c50d831c2ff344cc827d7f29416581c1.png
[41eeb99e8700461d9579d8ca7e6077b3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/c442b71c2b4d4013bce51238cb923e83.png
[f703d91fe6604a18b6b1ba92cffafe8c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/4c73ebb0b3f14d45872138af70233adf.png
[2e13f90485524da29e46a3e49345bfb6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/5c4626773921490ea9df497809866403.png