MySQL基于MSI文件安装Windows

逃离我推掉我的手 2022-10-30 11:29 9阅读 0赞

# 本章学习和介绍基于MSI文件ANZHUANG Windows版本的MySQL #

1.在浏览器中搜索MySQL官网地址[这里是官网][Link 1]；点击DOWNLOADS,再点击MSI下载如图![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70]  
2.选择如图![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 1]  
3.点击LOGIN,输入ORACLE账号信息![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 2]  
4.点击下载![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 3]  
5.点击下载好的文件安装![在这里插入图片描述][20210219140728907.png]  
6.选择“Full”：

<table> 
 <thead> 
  <tr> 
   <th>项</th> 
   <th>含义</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>Developer</td> 
   <td>MySQL开发者选项</td> 
  </tr> 
  <tr> 
   <td>Server only</td> 
   <td>只安装MySQL服务器</td> 
  </tr> 
  <tr> 
   <td>Client only</td> 
   <td>只安装MySQL客户端</td> 
  </tr> 
  <tr> 
   <td>Full</td> 
   <td>安装全部选项，但不安装MySQL开发者选项</td> 
  </tr> 
  <tr> 
   <td>Custom</td> 
   <td>自定义安装选项</td> 
  </tr> 
 </tbody> 
</table>

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 4]  
7.默认![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 5]  
8.点击YES![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 6]  
9.点击Execute开始安装MySQL![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 7]  
10.Show Details查看安装信息![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 8]  
11.next![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 9]  
12.next（根据自身服务器的情况）

<table> 
 <thead> 
  <tr> 
   <th>项</th> 
   <th>含义</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>Development Computer</td> 
   <td>这是一台开发计算机，其他应用程序将安装在上面，MySQL将使用最少的内存</td> 
  </tr> 
  <tr> 
   <td>Server Computer</td> 
   <td>服务器应用程序将在此服务器上运行计算机。选择此选项用于web或应用程序服务器.mysql将使用中等内存</td> 
  </tr> 
  <tr> 
   <td>Dedicated Computer</td> 
   <td>这台计算机专用于运行mysql数据库服务器。不其他服务器，如web服务器，将运行，mysql将使用所有可用的内存</td> 
  </tr> 
 </tbody> 
</table>

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 10]  
13.Authentication Method身份验证方法分别是

MySQL-8.x版本和MySQL-5.x版本![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 11]  
14.为root账户设置MySQL登录密码![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 12]

15.这里默认进行![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 13]  
16.点击Execute,点击Finish  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 14]  
17.产品配置点击next进入路由配置![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 15]  
18.点击Finish![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 16]  
19.点击Next![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 17]  
20.在这个对话框输入之前设置的root账户密码，点击Check检查是否正确，然后点击Next![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 18]  
21.这里单击Excute![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 19]  
22.点击Finish![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 20]  
23.Next![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 21]  
24.Finish![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 22]  
25.完成![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 23]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 24]

### 配置MySQL环境变量 ###

先找到环境变量在系统变量中  
1.新建`MYSQL_SERVER_HOME`  
值：在C盘`C:\Program Files\MySQL\MySQL Server 8.0`![在这里插入图片描述][2021021915090716.png]  
2.找到Path变量新建或增加`%MYSQL_SERVER_HOME%\bin`![在这里插入图片描述][20210219151457379.png]  
![在这里插入图片描述][20210219151505489.png]

### 测试MySQL ###

打开`CMD`,执行`mysql -uroot -p`输入设置的密码回车即可  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 25]

[Link 1]: https://www.mysql.com/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70]: /images/20221024/43a7cfbc7059420ab8e970ce228ae906.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 1]: /images/20221024/6ad1b7156224491b974a5310184f36ea.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 2]: /images/20221024/ed1e24263adc49e58b712a1b19d12fb5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 3]: /images/20221024/2f62551f2244424ea226f1322e7a7bb4.png
[20210219140728907.png]: /images/20221024/99c57520b0df4a4a8daf9d74fd2453a0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 4]: /images/20221024/596791ccbea8443fa9b09c95f7c43ec0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 5]: /images/20221024/32936116767c46ba8c5bf335d7df3149.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 6]: /images/20221024/be7fc7550fa14f968eeeb46265719449.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 7]: /images/20221024/a956c2024bc14d0f827aa8adb6833683.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 8]: /images/20221024/9240f208b2c1401e80de1d0fab3e7660.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 9]: /images/20221024/a4413f8e062146e2893f4ebe4e6b2260.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 10]: /images/20221024/0d29beb4d5dc4616a926a25a61f14b74.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 11]: /images/20221024/58f276851f134f88ae432da53e69e0f0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 12]: /images/20221024/6312b9f664b94162b502f520e5b4359d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 13]: /images/20221024/faeb49bc9c1341ac947b3c2de3fa5e0c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 14]: /images/20221024/2a78372e3ea04506915f3c633402167b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 15]: /images/20221024/e7689baeb9e24a8c8cfb6ba8f82a4227.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 16]: /images/20221024/297515d122c04f3c93178c57072cfdc6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 17]: /images/20221024/7f394a9d22e94d3297834ead75971aa4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 18]: /images/20221024/233fa1575dfb4895848985eb0d61f221.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 19]: /images/20221024/f7075113f36d44aea2a0c95902257014.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 20]: /images/20221024/57b1f5453a3a4c57b23e9aa08bacbcbf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 21]: /images/20221024/62d93135ba344f7aac074edaa6356e05.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 22]: /images/20221024/f030bdc231f4428e994da591585fd12e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 23]: /images/20221024/f02db3b850c54097aed508c46d1daf0f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 24]: /images/20221024/b1049dcef4784e389d7afd99a41375d0.png
[2021021915090716.png]: /images/20221024/4f728afce79e4a0b8021784a0d09c10a.png
[20210219151457379.png]: /images/20221024/afdd65b0c1da47f9b9cad774ed1e43a1.png
[20210219151505489.png]: /images/20221024/83ae46f357d54f7098a6439e5c787b2e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU3NjE0Ng_size_16_color_FFFFFF_t_70 25]: /images/20221024/739733243a0848a7a45df6abe767c4bb.png