MySQL的下载与安装（详细）

墨蓝 2024-04-08 13:37 91阅读 0赞

#### 1、先去官网下载安装包[https://www.mysql.com/downloads/][https_www.mysql.com_downloads] ####

![e2dc858f28d84176925cac7801fa3234.png][]

![b48fea8cbcfe4ff8bb63524b405ea3be.png][]

![f1134ffc486142ddb2d9d32de5a2261e.png][]

我下载的是8.0.21版本的，可以根据自己的需求进行下载。

![183fa8d6f85b46018d00be4ccb2d5d71.png][]

#### 2、下载完成安装包，双击进行安装。 ####

![d56a6a59a82443a28847eebc8799e15c.png][]

这儿我没有进行所有的安装，就没有按照默认的方式进行安装，选择了custom

![efc06952aec2438b9f28ce45b07f647d.png][]

![f75b7416bfb44b93a129187f2b7ce95a.png][]

![6458257fd85d440a880de07c0d94fd8d.png][]

![87ce1e5546634b7db3e7c8cae1559efe.png][]

![e3464774d42345a19ca3c27b438c5ec4.png][]

到达Account and Roles界面，就可以为数据库设置密码了

![10b701c7959f43f1b0398601c8d08c56.png][]

然后一直点击next或者execute、finish就完成了安装。

#### 3、配置环境变量 ####

![866397e9ea94422fadf1ea91ae7792da.png][]

![4995e6dccfec402bb68a8d17a96e9680.png][]

使用Win+R，输入cmd打开控制台，输入mysql指令进行验证，出现下图表示配置成功。

![618b8dda47df4dbdb4d9f2b69e214902.png][]

4、使用Navicat进行数据库连接，会出现下面 1251状态码的提示

![f2237c367a6d4ef7a6f89f79800bf8e1.png][]

以管理员的身份打开控制台， 在控制台输入下面的命令：

mysql -u root -p

回车键后，输入安装时设置的密码

![5a2c53a09c1b4892853227d213888714.png][]

依次输入下面指令：①将密码改为123456

alter user 'root'@'localhost' identified with mysql_native_password by '123456';

回车键，②刷新权限

flush privileges;

![f387fc9149aa46c9a19c98452434857a.png][]

完成以上操作，退出，再次使用Navicat进行连接，就可以正常连接了。

**怎么获取Navicat？ 在里面我会给出相应的下载链接。**

链接：[https://pan.baidu.com/s/1J1lhMcbj2Zt7RQyX92OfJg ][https_pan.baidu.com_s_1J1lhMcbj2Zt7RQyX92OfJg]  
提取码：8nnt

[https_www.mysql.com_downloads]: https://www.mysql.com/downloads/
[e2dc858f28d84176925cac7801fa3234.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/0e14a6e520214e80bb3ff1e2c7f0b4ca.png
[b48fea8cbcfe4ff8bb63524b405ea3be.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/d570a80c8f9b4cca8e9875e4eacba29e.png
[f1134ffc486142ddb2d9d32de5a2261e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/8218d3b44a6947fbbfbab26e0fc1f886.png
[183fa8d6f85b46018d00be4ccb2d5d71.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/798dfb6c2e4b4428b692ba618bf0d7bc.png
[d56a6a59a82443a28847eebc8799e15c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/755db19940934f43b953ff026080a15e.png
[efc06952aec2438b9f28ce45b07f647d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/640b2543a2c1481f99650c6427d7f29d.png
[f75b7416bfb44b93a129187f2b7ce95a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/67ea31105045432aa1ae8b1ef996c46c.png
[6458257fd85d440a880de07c0d94fd8d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/cea76f6827ab4efd9af41b2d103f80e2.png
[87ce1e5546634b7db3e7c8cae1559efe.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/e300b31a1edd490eaa20477313e5e81e.png
[e3464774d42345a19ca3c27b438c5ec4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/37d2fa41b2fa48b59ca41cedb64f5cdb.png
[10b701c7959f43f1b0398601c8d08c56.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/2862eab1dc7d44ccaa20502c8729199e.png
[866397e9ea94422fadf1ea91ae7792da.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/899c306b8e7444a7bb6ed7745a0a4fa2.png
[4995e6dccfec402bb68a8d17a96e9680.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/91f2fb5de0694fea9e219d5bba43d103.png
[618b8dda47df4dbdb4d9f2b69e214902.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/0dde64b2777a444e962292b7cd557172.png
[f2237c367a6d4ef7a6f89f79800bf8e1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/b0609bfb2f5b42f29aacaa721af43b6d.png
[5a2c53a09c1b4892853227d213888714.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/259d0591d8504c73a780f2c83e303655.png
[f387fc9149aa46c9a19c98452434857a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/e8125504057c4d19981b19d0c5bf6fbb.png
[https_pan.baidu.com_s_1J1lhMcbj2Zt7RQyX92OfJg]: https://pan.baidu.com/s/1J1lhMcbj2Zt7RQyX92OfJg%C2%A0