初始化MySQL报错的bug修复

小咪咪 2023-01-13 10:13 99阅读 0赞

bug：安装完MySQL后，使用mysqld --initialize --console初始化数据库时，弹出弹框报错：

## 由于找不到VCRUNTIME140\_1.dll,无法继续执行代码。重新安装程序可能会解决此问题。 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgwNDQ5Ng_size_16_color_FFFFFF_t_70][]

原因：这是缺少了动态链接库(.ddl文件), 跟mysql无关, 下载这个ddl文件即可

解决方法：

1、打开[https://cn.dll-files.com/vcruntime140\_1.dll.html][https_cn.dll-files.com_vcruntime140_1.dll.html]，下载第一个即可

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgwNDQ5Ng_size_16_color_FFFFFF_t_70 1][]

2、下载的压缩包里有个vcruntime140\_1.dll文件，把它复制到**C:\\Windows\\System32**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgwNDQ5Ng_size_16_color_FFFFFF_t_70 2][]

检验：输入mysqld --initialize --console不再弹出弹框了，而是执行成功了，说明bug解决

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgwNDQ5Ng_size_16_color_FFFFFF_t_70 3][]

至此，bug修复

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgwNDQ5Ng_size_16_color_FFFFFF_t_70]: /images/20221022/6d80bcf8c1f14f63868084876417b89b.png
[https_cn.dll-files.com_vcruntime140_1.dll.html]: https://cn.dll-files.com/vcruntime140_1.dll.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgwNDQ5Ng_size_16_color_FFFFFF_t_70 1]: /images/20221022/43478ce8d2da4f2ab7034e4646207740.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgwNDQ5Ng_size_16_color_FFFFFF_t_70 2]: /images/20221022/fda9e34b30674e7480b3216d7968b11c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgwNDQ5Ng_size_16_color_FFFFFF_t_70 3]: /images/20221022/c0ded63113b24891a4f7639a080d74f8.png