MySQL的安装与配置(详细)

我不是女神ヾ 2024-03-24 12:26 55阅读 0赞

首先去MySQL官网下载MySQL安装包 [https://dev.mysql.com/][https_dev.mysql.com]

点击DOWNLOADS

![897f197aa6e2467fab2276e117abc956.png][]

点击红色箭头处![283874951a314fb79fd69230ab12aed8.png][]

点击箭头处（为windows版）![39cba26f1bb04d28a93f3e431aa38c98.png][]

点击下载![c5d06a4a752c4a37bf156e4c9e4cef1b.png][]

下载完成后开始安装（以5.5为例）

1、双击打开mysql-5.5.28-winx64.msi

![7fd305540fb1411eadd9adf2ad263ded.png][]

2、点击“Next”，点击“接受协议”，点击“Next”

![4729e1aeb3aa4480a92f86336255ea1f.png][]

![941e3c53c4424e7a9e7780baa4fd660c.png][]

3、这里我们选择自定义安装，方便后面更改安装路径，然后点击“Next”

Typical（典型安装）

Installs the most common program features Recommended formost users

安装最常用的程序功能，建议大多数用户使用

Custom（自定义安装）

Allows users to choose which program features will be installed where they will be installed Recommended foradvanced users

允许用户选择安装的程序和选择安装的位置建议高级用户使用

Complete（安全安装）

All program features will be installed Requires the most disk space

将安装所有的功能程序，需要最多的硬盘空间

![41907bb6d01542e38e51a579cc0e9d96.png][]

4、点击“浏览”修改安装路径，然后点击“Next”

![f98a1a5d90fc4aca9b09ebd0c01ac38a.png][]

5、点击 “Install”开始安装，耐心等待

![0ab86e051a9f4c64b6ee4693f601656b.png][]

![c9f826f6445c4390b6b25963eea6ac5d.png][]

6、点击“Next”

![690a810c392247ad961bdee17209c23d.png][]

7、点击“完成”

![08b088d2aa61443f9898cf4415e21dff.png][]

8、点击“Next”

![ce02570e58974b81bc420556dbee7707.png][]

9、选择第一个，点击“Next”

![a0f6ae075cef455cbb416a791f18f266.png][]

10、选择第一个，然后点击“Next”

![6823c1538c8b4a85b19fe9351ea95843.png][]

11、选择第一个，然后点击“Next”

![2710fab478c142f298afd808a7bab365.png][]

12、点击“Next”

![5f982ee45e804c8aa31c6bbff1b19699.png][]

13、选择第三个，自定义同时连接个数20或30，然后点击“Next”

![1f4cbec9506a4ab79aec9fbe013be29c.png][]

14、点击“Next”，不做任何修改

![956c528fecbd40d0b21a537b7b007b36.png][]

15、选择第三个，将编码格式设置为 utf8 , 然后点击“Next”

![e10e133ebb0540b39729a163df647289.png][]

16、打上dos的勾意思是windows路径中包括bin目录，再点击“Next”

![4a15b88d9b12455aad1e54e5bd3a7542.png][]

17、打上勾，意思是启用从远程计算机的根访问权限，输入自己喜欢的用户名和密码再点击“Next”（如：**用户名：root**  **密码：root**）

![f19e01acf32e47bc9afb777583a66eef.png][]

18、点击Execute，耐心等待安装，可能需要几分钟……

![73fc662a437b4340bed844be326cd3cc.png][]

19、结果一：安装成功，点击“Finsh”

![3696d6bf450148d8b7ed242b88a88e36.png][]

![f116e1b9b5c84a8184326d358b638403.png][]

20、结果二：未响应

![33b4ba08a009499c90539ec745741a9a.png][]

**安装mysql最后一步未响应(解决方法)**

1，停止Mysql服务，卸载MySQL

3，在注册表查询mysql，全部删除（这一步很关键，安装失败主要原因就是注册表删不干净）

以下是彻底删除注册表方法：

（1）进入注册表：运行>>regedit 到以下界面(按下图方法删除)

![b761703b38334a77980d9c51ca048128.png][]

（2）再清理以下三个目录：

a.HKEY\_LOCAL\_MACHINE\\SYSTEM\\ControlSet001\\Services\\Eventlog\\Application\\MySQL

b.HKEY\_LOCAL\_MACHINE\\SYSTEM\\ControlSet002\\Services\\Eventlog\\Application\\MySQL

c.HKEY\_LOCAL\_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\Eventlog\\Application\\MySQL

MySQL注册表中的ControlSet001,ControlSet002,不一定是001和002,可能是ControlSet005、006之类,删除的时候,都删除就可以;

检查C:\\WINDOWS目录下是否有my.ini文件,将其删除

4，在c盘查询MySQL(可能会隐藏，显示隐藏文件就行了)，全部删除

5，重新安装MySQL,配置过程中选择之前未用过的名字（MySql4,若仍使用原来的MySql，则无法启动服务）

[https_dev.mysql.com]: https://dev.mysql.com/
[897f197aa6e2467fab2276e117abc956.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/584953cadc404f38bf532c065fbd0e89.png
[283874951a314fb79fd69230ab12aed8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/d5a8aa013e16422785d2224d87b4a4ec.png
[39cba26f1bb04d28a93f3e431aa38c98.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/331540c2621b4cf0b780a8ab890192bd.png
[c5d06a4a752c4a37bf156e4c9e4cef1b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/52564c4682604315b3afd6ab700fe394.png
[7fd305540fb1411eadd9adf2ad263ded.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/3e0496f3ab084779a6640f3be3845948.png
[4729e1aeb3aa4480a92f86336255ea1f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/94f4832366c048e997108e8c9b5101c8.png
[941e3c53c4424e7a9e7780baa4fd660c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/7a8ec5a6526541e58b682ac6a7a26a7c.png
[41907bb6d01542e38e51a579cc0e9d96.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/a561f4829bf84232bf062853e960b236.png
[f98a1a5d90fc4aca9b09ebd0c01ac38a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/4a35b0a10bfb4466a7e94e3329157a9b.png
[0ab86e051a9f4c64b6ee4693f601656b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/2d5f4f1cf0fc4a37b45aada7e4a9317e.png
[c9f826f6445c4390b6b25963eea6ac5d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/45d4524ba8b446c6b40dbc22aadbdce6.png
[690a810c392247ad961bdee17209c23d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/2eb3b27d7c904185b65ecf1156b8f71a.png
[08b088d2aa61443f9898cf4415e21dff.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/11f2293495ac4e2982bd1958fe8b9943.png
[ce02570e58974b81bc420556dbee7707.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/c86ef920a73347419722825406881853.png
[a0f6ae075cef455cbb416a791f18f266.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/c0dc371526c04077be4cf246a7cd50e1.png
[6823c1538c8b4a85b19fe9351ea95843.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/df893709405a414181ed27786cc8de53.png
[2710fab478c142f298afd808a7bab365.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/7dd5581d6726478389a9285011164282.png
[5f982ee45e804c8aa31c6bbff1b19699.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/06878141a0d147be99228b07257a0b2a.png
[1f4cbec9506a4ab79aec9fbe013be29c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/d84e39669e3e459783183a1d34d4a0c5.png
[956c528fecbd40d0b21a537b7b007b36.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/286dbfd313484623913eae3a4db35804.png
[e10e133ebb0540b39729a163df647289.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/3a784b75fc534de688535b3b20436567.png
[4a15b88d9b12455aad1e54e5bd3a7542.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/6296f4276310492390412d40ba639932.png
[f19e01acf32e47bc9afb777583a66eef.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/9c604508dc654541a798c08ce3bd2956.png
[73fc662a437b4340bed844be326cd3cc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/acbf3265a42148b79e25c7ca5d490c4d.png
[3696d6bf450148d8b7ed242b88a88e36.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/865da99e974a48c8b201221fa6c74310.png
[f116e1b9b5c84a8184326d358b638403.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/ccd7905c028148618d6253b051e348dd.png
[33b4ba08a009499c90539ec745741a9a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/7cfa1f57ad5345f989459fe25fed0a6f.png
[b761703b38334a77980d9c51ca048128.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/77b22820a3964cb0b28d9d1855773a5a.png