MySQL 安装程序卡在“启动服务”上
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/26047524/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MySQL Installer Stuck on "Starting Service"
提问by Jayson H
I recently had a successful install of MySQL 5.6.21 using the MySQL installer on Windows Server 2012 R2. I needed to make some modifications and tried to re-install.
我最近在 Windows Server 2012 R2 上使用 MySQL 安装程序成功安装了 MySQL 5.6.21。我需要进行一些修改并尝试重新安装。
Now MySQL is hanging on "Starting Service".
现在 MySQL 挂在“启动服务”上。
I've tried the following:
我尝试了以下方法：
- Uninstall using Control Panel
- Delete Service using "sc delete MySQL56"
- Delete all MySQL files from "Program Files" & "c:\programdata"
- 使用控制面板卸载
- 使用“sc delete MySQL56”删除服务
- 从“Program Files”和“c:\programdata”中删除所有 MySQL 文件
Has anyone seen this problem? If so, how were you able to fix it?
有没有人见过这个问题？如果是这样，你是如何修复它的？
回答by MonkeyZeus
TURN OFF WINDOWS FIREWALL COMPLETELY BEFORE INSTALLING
安装前完全关闭 WINDOWS 防火墙
This was one of the only threads I could find on this issue and the current answers did not cut the mustard for me.
这是我在这个问题上能找到的唯一线索之一，目前的答案并没有为我减少芥末。
MySQL 5.6.21, both x86 and x64, did not want to get past "Starting Server" and would give me the "MySQL install taking longer than expected" message.
MySQL 5.6.21（x86 和 x64）不想通过“启动服务器”，并且会给我“MySQL 安装所需的时间比预期更长”的消息。
I tried all of the registry cleaner, folder deletions, etc to no avail.
我尝试了所有的注册表清理、文件夹删除等都无济于事。
I am running Windows 7 x64 and I finally decided to check the event viewer to find this:
我正在运行 Windows 7 x64，我最终决定检查事件查看器以找到以下内容：
0x80070422 turns out to be some unspecified firewall error and boom, it struck me like lightning.
0x80070422 原来是一些未指定的防火墙错误和繁荣，它像闪电一样击中了我。
I hope this post helps future visitors!
我希望这篇文章可以帮助未来的访客！
回答by Nenad Bulatovic
I just had that very same problem on Windows 7 pro 64 bit with latest mysql-installer-web-community-5.6.23.0.msi installer and I resolved it thisway
我刚刚在使用最新的 mysql-installer-web-community-5.6.23.0.msi 安装程序的 Windows 7 pro 64 位上遇到了同样的问题，我是这样解决的
Installer stuck because user who is supposed to start service is set erroneously.
安装程序卡住，因为应该启动服务的用户设置错误。
回答by Alessandro Nardinelli
I was blooding trying to install MySQL Community Server 5.5.43 on a Windows Server 2008 R2 Enterprise. On Configuration Screen, the process stops at the "Starting Server." phase.
我正在尝试在 Windows Server 2008 R2 Enterprise 上安装 MySQL Community Server 5.5.43。在配置屏幕上，该过程在“启动服务器”处停止。阶段。
Okay, first i tried to configure from the installer i downloaded, right after i installed the MySQL. No success at all.
好的，首先我尝试从我下载的安装程序进行配置，就在我安装 MySQL 之后。根本没有成功。
If you already did installed it, please go and unninstall it right from your downloaded file. It both Install and removes the files. Then go to the C:/Program Files/ and delete the MySQL folder. Next, go to Control Panel, Programs, Unninstall and remove the MySQL Community Installer. Rebbot your machine.
如果您已经安装了它，请直接从您下载的文件中卸载它。它既安装又删除文件。然后转到 C:/Program Files/ 并删除 MySQL 文件夹。接下来，转到控制面板、程序、卸载并删除 MySQL 社区安装程序。Rebbot 你的机器。
Reinstall the software with your downloaded file, but DO NOT PROCEED TO CONFIGURATION! Close the installer when the installation process finishes.
使用您下载的文件重新安装软件，但不要继续进行配置！安装过程完成后关闭安装程序。
Now, go to C:/program files/MySQL/ MySQL Server 5.5/bin and run (as Administrator) the MySQLInstanceConfig.exe. This file represent the configuration that was supposed to be done by the installer. Folow the procedures and your MySQL Server shoud now recognize that your service has started, passing the "Start Service" phase.
现在，转到 C:/program files/MySQL/MySQL Server 5.5/bin 并（以管理员身份）运行 MySQLInstanceConfig.exe。此文件表示应该由安装程序完成的配置。按照步骤操作，您的 MySQL 服务器现在应该识别出您的服务已经启动，通过了“启动服务”阶段。
Dolphin Magic!
海豚魔术！
回答by Alex Schr?der
We had the same problem. Didn't work on the server, worked on our personal workstation. As it turns out, I had an environment variable set as follows:
我们遇到了同样的问题。不在服务器上工作，在我们的个人工作站上工作。事实证明，我有一个环境变量设置如下：
ALLUSERSPROFILE=C:\ProgramData
On Windows 7 Enterprise, this is also set but the directory does not exist. So we killed the installer, went to the config file C:\Program Files\MySQL\MySQL Server 5.5\my.iniand changed the setting of datadirto a path that existed.
在 Windows 7 Enterprise 上，也设置了此项，但该目录不存在。所以我们杀死了安装程序，转到配置文件C:\Program Files\MySQL\MySQL Server 5.5\my.ini并将设置更改为datadir存在的路径。
Restart the installer (MySQLInstanceConfig.exe, run as administrator) and "reconfigure" your service. That should work.
重新启动安装程序（MySQLInstanceConfig.exe，以管理员身份运行）并“重新配置”您的服务。那应该工作。
回答by Ferhat KO?ER
I have same program
我有同样的程序
Event viewer detail:
事件查看器详细信息：
Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'For more information, see Help and Support Center at http://www.mysql.com.
插件 keyring_file 报告：'keyring_file 初始化失败。请检查 keyring_file_data 是否指向可读的密钥环文件或可以在指定位置创建密钥环文件。在提供正确的密钥环文件路径之前，密钥环文件将保持不可用状态。有关更多信息，请参阅http://www.mysql.com 上的帮助和支持中心。
My resolved is:
我的解决是：
I Installed data Path and mysql Base Dir on same disk
我在同一个磁盘上安装了 data Path 和 mysql Base Dir
example
例子
(This is working)
（这是工作）
Install Directory : D:\MYSQL
Data Director : D:\myData
(This is not working because different disk)
（这不起作用，因为不同的磁盘）
Install Directory : C:\MYSQL
Data Director : D:\myData
回答by Anurag_BEHS
I have faced the similar issue during Mysql Upgrade from version 5.7 to 8 .
我在 Mysql 从 version 5.7 升级到 8 期间遇到了类似的问题。
I have tried by stopping the service (Go to run ->services.msc-> look for Msql5.7) and manually staring Msql8 .After that all the sequential steps where completed and my configuration was completed .
我已经尝试停止服务（转到运行 ->services.msc-> 查找 Msql5.7）并手动启动 Msql8 。之后所有顺序步骤都完成了，我的配置也完成了。
Followed by changing the environment variable Path to your latest Mysql bin path.
然后将环境变量 Path 更改为您最新的 Mysql bin 路径。
There you are , good to go and use your MySQL :)
你到了，很高兴去使用你的 MySQL :)
