mysql配置在“启动服务器"处停止. [英] mysql configuration stops at "starting server"

问题描述

我正在Windows 8计算机上安装MySQL安装程序.在服务器配置过程中，它停留在启动服务器"上，并且不会继续前进.相同的日志是:

I was installing MySQL installer on my windows 8 machine. During the server configuration process, it gets stuck at "starting server" and doesn't move any further. The log for the same is :

开始配置步骤:停止服务器[如果需要]
结束的配置步骤:停止服务器[如果需要]

Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]

开始配置步骤:写入配置文件
结束配置步骤:写入配置文件

Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file

开始配置步骤:更新防火墙
在端口3306上为MYSQL56添加防火墙规则.
已成功添加防火墙规则.
结束的配置步骤:更新防火墙

Beginning configuration step: Updating firewall
Adding firewall rule for MYSQL56 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall

开始配置步骤:调整Windows服务[如果需要]
尝试授予网络服务需要文件系统权限.
已授予权限.
添加新服务
添加了新服务
结束的配置步骤:调整Windows服务[如果需要]

Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding a new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]

我已经尝试了以下方法:-
*卸载与MySQL相关的所有程序.
*从C:\ Program Files删除MySQL文件夹.
*清除了我的注册表.
然后重新安装该程序，但都徒劳无功.

I have already tried the following:-
* Un-installed all the programs that were in any way related to MySQL.
* Deleted the MySQL folder from C:\Program Files.
* Cleared my registry.
and then re-installed the program, but all in vain.

链接 MySQL Installer停留在启动服务"上同样的问题，但是提供的解决方案对我不起作用.

The link MySQL Installer Stuck on "Starting Service" also shows the same problem but the solution provided is not working for me.

推荐答案

这就是我所做的:

1. 使用mysql-installer-web-community-5.6.23.0.msi安装了它
2. 出于我的目的，我选择自定义"安装MySQL服务器5.6.22-X64和MySQL连接器->连接器ODBC/5.3.4-64
3. 下一步->执行-(准备配置)->下一步
4. 配置类型:开发计算机，所有默认设置(TCP/IP，端口:3306，打开防火墙)
5. 键入MySQL根密码
6. MySQL用户帐户->添加用户(用户名，密码，确定)->下一步
7. 将MySQL Server配置为Windows服务(已选中)
8. Windows服务名称:MySQL56(默认)
9. 在系统启动时启动MySQL服务
10. 这是至关重要的(在这里是错误的):以...身份运行服务 标准系统帐户(已选中-但将被忽略，即BUG)
11. 下一步->执行，安装在启动服务器上挂起，因此请等待一段时间以超时(或选择不这样做).当对话框(可能被其他窗口覆盖)弹出时，显示消息配置MySQL Server所花费的时间比预期的长...，在此单击确定(以便等待更长的时间)
12. 同时转到开始"->控制面板"->管理工具"->服务"->找到MySQL56"，右键单击它->属性"->选择登录"选项卡，然后选择错误"->虽然本地系统帐户是选中，以某种方式已选择此帐户:网络服务(使用某些密码)->选择登录身份:本地系统帐户，允许服务与桌面交互->应用->返回常规标签
13. 在常规选项卡上，单击启动"按钮以启动服务，就在这里！服务已启动！单击确定"关闭"MySQL56属性"对话框.关闭服务对话框.关闭管理工具.关闭控制面板.
14. 到那时(当您关闭那些对话框时)，当您查看MySQl Installer对话框时，所有步骤都已完成并检查:启动服务器，应用安全性...创建用户帐户.更新开始"菜单链接
15. 用Finish确认-> Next-> Finish

1. Installed it with mysql-installer-web-community-5.6.23.0.msi
2. For my purposes I selected "Custom" install with MySQL servers 5.6.22 - X64 and MySQL Connectors -> Connector ODBC/5.3.4 - 64
3. Next -> Execute -(ready to configure) -> Next
4. Config type: Development machine, all defaults (TCP/IP, Port: 3306, Open firewall)
5. Typed in MySQL Root Password
6. MySQL user Accounts -> Add user (username, password, OK) -> Next
7. Configure MySQL Server as a Windows Service (CHECKED)
8. Windows Service Name: MySQL56 (default)
9. Start the MySQL Serve at System Startup
10. THIS IS CRUCIAL (BUG IS HERE): Run Service as... Standard System Account (CHECKED - but it will be disregarded and that is BUG)
11. Next -> Execute, Installation hangs on Starting server, so wait for a while to time out (or don't, your choice). When Dialog (might be covered with other windows) popup with message "Configuration of MySQL Server is taking longer than expected..., here click OK (so to wait longer)
12. Meanwhile go to Start -> Control Panel -> Administrative Tools -> Services -> find MySQL56, right click on it -> Properties -> select Log On Tab AND HERE IS BUG -> Although Local System Account was selected, Somehow "This account: Network Service (with some password) was selected -> Select Log on as: Local System Account, Allow service to interact with desktop -> Apply -> Go back on general tab
13. On general tab click on "Start" button to start service and here it is! Service is started! Click on OK to close MySQL56 Properties dialog. Close Services dialog. Close Administrative tools. Close control panel.
14. And by that time (while you were closing those dialogs) when you look at MySQl Installer Dialog all steps are finished and checked: Starting Server, Applying security... Creating user accounts.. Updating Start menu link
15. Confirm with Finish -> Next -> Finish

就这样，快乐的MySQL-ing:)

That's it, happy MySQL-ing :)

这篇关于mysql配置在“启动服务器"处停止.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！