MySQL重装——Database initialization failed错误处理

卸载Mysql

• 笔者由于跟着网上的教程将mysql安装到了C盘，忘记了可以走更改路径这条路，在卸载Mysql的路上一去不复返。
• 试过网上诸多重装方案，大体均为以下步骤：控制面板卸载MySQL→删除注册表→删除ProgramData、Application Data、Program Files (x86)、Program Files里面的MySQL→删除环境变量，然后重启。
• 最终打开的安装包依旧是“welcome back”
• 一度令我想要重装系统

以上这种情况就是没有卸载干净

• 于是尝试了一个新的方法，借助geek软件删除有关MySQL的所有文件夹、注册表等信息。
• 下面放一个geek百度网盘下载版：百度网盘 提取码：7rbo
• 功夫不负有心人，终于卸载完毕了

重装MySQL

• 成功进行重新安装，出现的页面会和第一次安装一样，如果不是，则表示还没有删干净。
• 存档一个MySQL安装教程：MySQL+Navicat安装配置教程（超级详细、保姆级）
• 笔者安装的是最新版，与链接安装的版本不同，即没有链接中的提示→【若电脑中没有这个环境，会提示安装“Microsoft Visual c++ 2013”环境】
• 因此，需要自行下载一个Microsoft Visual C++ 2013。
• 存档一个Microsoft Visual C++ 2013链接：百度网盘
  提取码：kalu
• 解释一下为什么要安装这个，因为不安装的话会出现如下错误：

Beginning configuration step: Writing configuration fileSaving my.ini configuration file...Saved my.ini configuration file.Ended configuration step: Writing configuration fileBeginning configuration step: Updating windows Firewall rulesAdding a Windows Firewall rule for MySQL81 on port 3306.Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=tcp localport=3306 dir=in action=allow确定。Successfully added the Windows Firewall rule.Adding a Windows Firewall rule for MySQL81 on port 33060.Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow确定。Successfully added the Windows Firewall rule.Ended configuration step: Updating Windows Firewall rulesBeginning configuration step: Adjusting Windows serviceAttempting to grant Network Service require filesystem permissions.Granted permissions.Adding new serviceNew service addedEnded configuration step: Adjusting Windows serviceBeginning configuration step: Initializing database (may take a long time)Attempting to run MySQL Server with --initialize-insecure option...Starting process for MySQL Server 8.0.31...Starting process with command: D:\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="E:\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...Using jemalloc.dll for my_malloc and ut::malloc etc.D:\MySQL\MySQL Server 8.0\bin\mysqld.exe: Empty value for 'open_files_limit' specified.Process for mysqld, with ID 15044, was run successfully and exited with code 1.Failed to start process for MySQL Server 8.0.31.Database initialization failed.Ended configuration step: Initializing database (may take a long time)

• 装上VcRedist.x86即可执行【笔者需要重启电脑才成功】。

来源地址：https://blog.csdn.net/weixin_45489658/article/details/128994829