MySQL 服务未在 Windows 中启动
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14037607/
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 service is not starting up in Windows
提问by VijayM
FROM C:\ProgramData\MySQL\MySQL Server 5.5\Data\purplista.err:
121226 13:12:06 [Note] Plugin 'FEDERATED' is disabled.
121226 13:12:06 InnoDB: The InnoDB memory heap is disabled
121226 13:12:06 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121226 13:12:06 InnoDB: Compressed tables use zlib 1.2.3
121226 13:12:06 InnoDB: Initializing buffer pool, size = 107.0M
121226 13:12:06 InnoDB: Completed initialization of buffer pool
121226 13:12:06 InnoDB: highest supported file format is Barracuda.
I am facing the above issue while starting Mysql from mySql workbench. If I start it from windows services it got stopped automatically in few seconds.
我在从 mySql 工作台启动 Mysql 时遇到了上述问题。如果我从 Windows 服务启动它，它会在几秒钟内自动停止。
Note:If I uninstall and re-install it wrks for sometime but thing after few days I am facing this issue again
注意：如果我卸载并重新安装它一段时间，但几天后我再次面临这个问题
Could any one help me to fix this issue?
有人能帮我解决这个问题吗？
回答by Paul T. Rawkeen
For
为了
121226 13:12:06 InnoDB: The InnoDB memory heap is disabled
you can try set innodb_use_sys_malloc = 0in my.cnf. More reference documentation is here.
你可以试试 set innodb_use_sys_malloc = 0in my.cnf。更多参考文档在这里。
Also:
还：
you can try clear contents of
mysql-bin.index. Related question is here.if you have some antivirus/firewall software, try turn it off and check the functionality, bec. it can be the reason of some issues.
您可以尝试清除
mysql-bin.index. 相关问题在这里。如果您有一些防病毒/防火墙软件，请尝试将其关闭并检查功能，bec。这可能是某些问题的原因。
回答by Arun Killu
What i think the problem might be is .
我认为问题可能是。
- give MySql access to the firewall fix this
- you should allow MySQL server (mysqld.exe) to start and allow access to port 3306.
- Try to decrease innodb_buffer_pool_size in my.ini file then. Set it to 1G and check if this will allow service to start.
- 让 MySql 访问防火墙解决这个问题
- 您应该允许 MySQL 服务器 (mysqld.exe) 启动并允许访问端口 3306。
- 然后尝试减小 my.ini 文件中的 innodb_buffer_pool_size。将其设置为 1G 并检查这是否允许服务启动。
notemysql uses tcp connection
notemysql 使用 tcp 连接
