MySQL--下载/安装/配置--教程/方法--Windows

忘是亡心i 2022-08-28 11:52 329阅读 0赞

原文网址：[MySQL--下载/安装/配置--教程/方法--Windows\_IT利刃出鞘的博客-CSDN博客][MySQL--_--_--Windows_IT_-CSDN]

# **下载地址** #

**1. 网址入口**

在浏览器中打开[MySQL][]，进入MySQL的官方网站，国内的网打开可能有点儿慢。  
[MySQL :: MySQL Community Downloads][MySQL _ MySQL Community Downloads] 这个网址很快。

**2. 在打开的网页中选择downloads标签，如下图：**

[![image][]][image 1]

**3. 下载Community版本**

在打开的标签页中，滑到页面的最下面，可以看到MySQL Community Edition [Community (GPL) Downloads »][Community _GPL_ Downloads] 的字样，点击[Community (GPL) Downloads »][Community _GPL_ Downloads]，如下图：

[![image][image 2]][image_image 2]

在之后打开的页面中，点击 **[MySQL Community Server][] (GPL)，如下图：**

[![image][image 3]][image_image 3]

**4. 在之后打开的页面中就可以看到相关的下载项了，如下图：**

[![image][image 4]][image_image 4]

第一个红色框：选择操作系统。这里我们选择Microsoft Windows

第二个红色框：Recommended download。如果是新手建议点击这个，就是普通的安装文件，直接一路next就安装完了

第三个红色框：Other downloads。可以看到前两个是正式版，后两个是debug版，一般选择前两个，根据自己的机器32位还是64位选择下载，下载下来是个zip文件，安装的自己配置，相对复杂

**5. 如果选择了MySQL Installer进去页面之后，如下：**

[![image][image 5]][image_image 5]

第一个：运行时使用网络在线安装

第二个：离线安装包，安装时无需网络。（推荐）

**为防止有的同学无法下载，这里贴出下载链接：**

MySQL Installer 5.7 ：[http://cdn.mysql.com//Downloads/MySQLInstaller/mysql-installer-community-5.7.16.0.msi][http_cdn.mysql.com_Downloads_MySQLInstaller_mysql-installer-community-5.7.16.0.msi]

MySQL 5.7 Windows (x86, 32-bit), ZIP Archive ：[http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.16-win32.zip][http_cdn.mysql.com_Downloads_MySQL-5.7_mysql-5.7.16-win32.zip]

MySQL 5.7 Windows (x86, 64-bit), ZIP Archive ：[http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.16-winx64.zip][http_cdn.mysql.com_Downloads_MySQL-5.7_mysql-5.7.16-winx64.zip]

MySQL Installer 只有32位的，没有64位的。

# 法1：图形界面安装法 #

**1. 双击安装文件（.msi）**

![20210810104538134.png][]

**可能的问题**

[![image][image 6]][image_image 6]

意思就是MySQL需要.NET Framework4.0才能继续安装，那我们就安装一下

用浏览器打开[Download Microsoft .NET Framework 4（独立安装程序） from Official Microsoft Download Center][Download Microsoft .NET Framework 4_ from Official Microsoft Download Center]，点击下载，就可以很顺利的下载下来了，下载完直接安装

[![image][image 7]][image_image 7]

[![image][image 8]][image_image 8]

**2.选择安装类型**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70][]

*  “Developer Default”：包含MySQL其它组件，像MySQL Workbench，MySQL for Excel等
 *  “Server only”：只安装MySQL数据库服务端。（也会包含客户端的命令行程序）
 *  “Custom”：可指定安装位置等，否则，安装到C盘。

本处我选择：“Server only”，然后点击“Next”

**3. 选择安装位置**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 1][]

点击next

**4.执行安装**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 2][]

点击：Execute

**5.配置密码等**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 3][]

点击next

配置服务器类型和网络（默认即可）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 4][]

配置授权类型（默认即可）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 5][]

配置用户

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 6][]

Root Account Password：填写MySQL中root用户的密码，长度最低为4位

MySQL User Accounts：可以添加普通用户。一般开发用不用再建立用户了，直接使用root就可以

**6.配置服务启动方式、自启动**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 7][]

第一个选择框：是否将MySQL注册为Windows服务

第二个文本框：注册的服务名字。后边用命令启动它时用这个名字

第三个选择框：是否在系统启动时自动启动。本处取消选中它

**7.应用配置**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 8][]

点击Execute

**8.结束配置**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 9][]

点击finish

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 10][]

点击Next

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 11][]

点击Finish

**9.测试连接**

打开MySQL命令行工具

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 12][]

输入密码，如下图所示即为成功

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 13][]

**注意**

如果安装完MySQL8.0出现如下问题，是因为MySQL8.0不支持win7，详情见：  
[MySQL :: Supported Platforms: MySQL Workbench][MySQL _ Supported Platforms_ MySQL Workbench]  
解决方法：下载MySQL6.3.10版本并安装。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 14][]

# **法2：使用zip安装包** #

**1. 解压**

首先解压你下载的安装包，把这个文件夹移动到你想安装mysql的地方，也就是你移动到的目录就是安装mysql的目录，比如我的放在D:\\Program Files下面。

[![image][image 9]][image_image 9]

**2. 设置环境变量**

打开我的电脑->属性->高级->环境变量，在系统变量里选择PATH,在其后面添加: 你的mysql bin文件夹的路径 (如:D:\\Program Files\\mysql-5.7.16-winx64\\bin )

[![image][image 10]][image_image 10]

**3.修改配置文件**

在根目录中（本处是：D:\\Program Files\\mysql-5.7.16-winx64\\）创建my.ini文件；（注意：只有basedir和datadir两项是必需的。my.ini文件的编码必须是英文编码（如windows中的ANSI），不能是UTF-8或GBK等）。

[mysqld]
    basedir=D:\Program Files\mysql-5.7.16-winx64\
    datadir=D:\Program Files\mysql-5.7.16-winx64\data
    port = 3306
    max_connections=200
    character-set-server=utf8
    default-storage-engine=INNODB
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    
    [mysql]
    default-character-set=utf8

**4.mysql服务的安装、初始化、设置**

然后以管理员身份运行cmd.exe；（命令窗口左上角有“管理员三个字即可”）。

（1）mysqld -install

（2）mysqld --initialize-insecure --user=mysql -- 初始化

（3）net start mysql

**5.登录**

cmd进入后，输入mysql -u root -p，刚开始没有密码，直接回车；quit 退出。

**6.修改密码**

mysqladmin -u root -p password 新密码=> 回车=> 输入旧密码（如果刚安装，不用输入）=> 回车

**7.退出**

quit或者exit

**8.重启MySQL**

net stop mysql  
net start mysql

这个比图形安装（上边的法1）的更简单

# 问题解决 #

执行mysql -v时报错：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob25nYWl5aXNoZW5nXw_size_16_color_FFFFFF_t_70]

这种错误是由于未安装 vcredist 引起的

下载 vcredist 地址：

[最新支持的 Visual C++ 下载][Visual C_]

[Download Visual C++ Redistributable Packages for Visual Studio 2013 from Official Microsoft Download Center][Download Visual C_ Redistributable Packages for Visual Studio 2013 from Official Microsoft Download Center]

安装刚才下载的那个软件，位置默认即可，安装成功后重新执行即可成功。

# **Linux下安装mysql** #

下载地址：[MySQL :: Download MySQL Administrator (Archived Versions)][MySQL _ Download MySQL Administrator _Archived Versions]

安装教程：  
[linux下安装mysql,mysql administrator,mysql query browser\_飞鹰0苍狼\_新浪博客][linux_mysql_mysql administrator_mysql query browser_0]  
[Linux下安装MySQL管理工具MySQL Administrator和MySQL Query Browser\_运维\_sunrier的专栏-CSDN博客][Linux_MySQL_MySQL Administrator_MySQL Query Browser_sunrier_-CSDN]

[MySQL--_--_--Windows_IT_-CSDN]: https://knife.blog.csdn.net/article/details/120515203
[MySQL]: https://www.mysql.com/
[MySQL _ MySQL Community Downloads]: https://dev.mysql.com/downloads/
[image]: /images/20220828/65d9c2d1dfc14b2a990ae35c351126a3.png
[image 1]: http://images2015.cnblogs.com/blog/914233/201610/914233-20161019190545888-55480476.png
[Community _GPL_ Downloads]: http://dev.mysql.com/downloads/
[image 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvOTE0MjMzLzIwMTYxMC85MTQyMzMtMjAxNjEwMTkxOTA1NTE1MjktMTc2MjI1NjA0NS5wbmc?x-oss-process=image/format,png
[image_image 2]: /images/20220828/bbd9d18b17ff4c80b83f085f7c1b0ccc.png
[MySQL Community Server]: http://dev.mysql.com/downloads/mysql/
[image 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvOTE0MjMzLzIwMTYxMC85MTQyMzMtMjAxNjEwMTkxOTA1NTI0MjAtOTM5NTgzNDE0LnBuZw?x-oss-process=image/format,png
[image_image 3]: /images/20220828/2de523605f3447d4961be95e4fab4e38.png
[image 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvOTE0MjMzLzIwMTYxMC85MTQyMzMtMjAxNjEwMTkxOTA1NTU2MzgtMTk2NjA4OTc1LnBuZw?x-oss-process=image/format,png
[image_image 4]: /images/20220828/8a99988fd9ee4d4689dea3a29228ffe1.png
[image 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvOTE0MjMzLzIwMTYxMC85MTQyMzMtMjAxNjEwMTkxOTA1NTY5OTgtMTQzOTk4NzU5MS5wbmc?x-oss-process=image/format,png
[image_image 5]: /images/20220828/8038be1ef05b4cf48532d83f022f6880.png
[http_cdn.mysql.com_Downloads_MySQLInstaller_mysql-installer-community-5.7.16.0.msi]: http://cdn.mysql.com//Downloads/MySQLInstaller/mysql-installer-community-5.7.16.0.msi
[http_cdn.mysql.com_Downloads_MySQL-5.7_mysql-5.7.16-win32.zip]: http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.16-win32.zip
[http_cdn.mysql.com_Downloads_MySQL-5.7_mysql-5.7.16-winx64.zip]: http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.16-winx64.zip
[20210810104538134.png]: /images/20220828/14320ff9599a4c89939c37b90ccc7ec7.png
[image 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvOTE0MjMzLzIwMTYxMC85MTQyMzMtMjAxNjEwMTkxOTA2MDQzODgtNjExMjgwNTE5LnBuZw?x-oss-process=image/format,png
[image_image 6]: /images/20220828/3047cca1e8a6460695fc794beadb0c87.png
[Download Microsoft .NET Framework 4_ from Official Microsoft Download Center]: http://www.microsoft.com/zh-cn/download/details.aspx?id=17718
[image 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvOTE0MjMzLzIwMTYxMC85MTQyMzMtMjAxNjEwMTkxOTA2MDg0MjAtNjg2NDYzMDAzLnBuZw?x-oss-process=image/format,png
[image_image 7]: /images/20220828/fc875df5eb714cb889b8f43d809e3bdb.png
[image 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvOTE0MjMzLzIwMTYxMC85MTQyMzMtMjAxNjEwMTkxOTA2MTMyMDEtMTMyNjQ1NDEucG5n?x-oss-process=image/format,png
[image_image 8]: /images/20220828/c1af2e52f08148efb0886ad9a6b1cfca.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70]: /images/20220828/2908d2927cbe4221ac69224c581de426.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 1]: /images/20220828/560bd1e18788478e8734c41492572161.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 2]: /images/20220828/10625ada3c8e49c592981616544b93f1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 3]: /images/20220828/c30a14907fc24aadad60f61fc2849dc8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 4]: /images/20220828/8c2ef55c10834553b10de9397c6e13b8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 5]: /images/20220828/08f72655728948f6895d02fbffd9280f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 6]: /images/20220828/7b057bae726d48b8b97b8948b222bafb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 7]: /images/20220828/55a24c8b20f24cfaa8310429c9ec2594.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 8]: /images/20220828/f420d02a187546f99c6d3e814edad06a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 9]: /images/20220828/3fc88bbcc30643e5b337a3ce785534e1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 10]: /images/20220828/8572cc8200e14a6dbc7c575b5c7c2c05.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 11]: /images/20220828/b7bac6381885442484f370512b9f2faa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 12]: /images/20220828/efc07d1ed15546b294f039ceb785904b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 13]: /images/20220828/dc022049160b4260bb61f2d3ee03d552.png
[MySQL _ Supported Platforms_ MySQL Workbench]: https://www.mysql.com/support/supportedplatforms/workbench.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70 14]: /images/20220828/3b4a72a354d3432fb49e40f4016f9359.png
[image 9]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvOTE0MjMzLzIwMTYxMC85MTQyMzMtMjAxNjEwMTkyMDM4MzU0OTgtMTUyMTI1NDUxOC5wbmc?x-oss-process=image/format,png
[image_image 9]: /images/20220828/ef2b6f2112044757a2d7def1f31f56c5.png
[image 10]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvOTE0MjMzLzIwMTYxMC85MTQyMzMtMjAxNjEwMTkyMDM4MzYzNTctOTIyMTM2NTkyLnBuZw?x-oss-process=image/format,png
[image_image 10]: /images/20220828/f935fc1a866443e7bdfa9046173bd613.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob25nYWl5aXNoZW5nXw_size_16_color_FFFFFF_t_70]: /images/20220828/adc87870ede74ef3ba7bbc9b653457b8.png
[Visual C_]: https://support.microsoft.com/zh-cn/help/2977003/the-latest-supported-visual-c-downloads
[Download Visual C_ Redistributable Packages for Visual Studio 2013 from Official Microsoft Download Center]: https://www.microsoft.com/zh-CN/download/details.aspx?id=40784
[MySQL _ Download MySQL Administrator _Archived Versions]: https://downloads.mysql.com/archives/administrator/
[linux_mysql_mysql administrator_mysql query browser_0]: http://blog.sina.com.cn/s/blog_14f1cd81a0102wzlf.html
[Linux_MySQL_MySQL Administrator_MySQL Query Browser_sunrier_-CSDN]: https://blog.csdn.net/sunrier/article/details/7572299