mysql 无法在我的本地主机中启动服务
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/17464507/
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 unable to start service in my localhost
提问by kishore chowdary
when i start mysql service that shows bellow error.
当我启动显示波纹管错误的 mysql 服务时。
"Could not start the MySql service on local Computer
Error 1067: The process terminited unexpectedly"
when i check error logs it shows bellow error
当我检查错误日志时，它显示以下错误
130704 12:58:44 [Note] Plugin 'FEDERATED' is disabled.
130704 12:58:44 InnoDB: Initializing buffer pool, size = 47.0M
130704 12:58:44 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes InnoDB: than specified in the .cnf file 0 20971520 bytes!
130704 12:58:44 [ERROR] Plugin 'InnoDB' init function returned error.
130704 12:58:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130704 12:58:44 [ERROR] Unknown/unsupported table type: INNODB
130704 12:58:44 [ERROR] Aborting
130704 12:58:44 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
Help me to resolve this problem
帮我解决这个问题
回答by Nicole Stutz
I googled and found this problem in the mysql page. It may help you.
我用谷歌搜索并在 mysql 页面中发现了这个问题。它可能会帮助你。
try this answers: http://forums.mysql.com/read.php?22,144428,249656#msg-249656
试试这个答案：http: //forums.mysql.com/read.php?22,144428,249656#msg-249656
actually the next answer from Richard Lee may help more. http://forums.mysql.com/read.php?22,144428,250105#msg-250105
实际上，Richard Lee 的下一个答案可能会有所帮助。 http://forums.mysql.com/read.php?22,144428,250105#msg-250105
回答by Fabio
Thank you, had added some changes to my.cnfas query_cache_limit = 2M, query_cache_size = 64M, join_buffer_size = 4M, thread_cache_size = 80, table_cache = 264, innodb_buffer_pool_size = 2400M, here in my bank and stopped, I returned the original file with the only change innodb_buffer_pool_size = 2400M. Give worked.
谢谢，已经对my.cnfas添加了一些更改query_cache_limit = 2M, query_cache_size = 64M, join_buffer_size = 4M, thread_cache_size = 80, table_cache = 264, innodb_buffer_pool_size = 2400M，在我的银行这里停止了，我返回了原始文件，只有更改innodb_buffer_pool_size = 2400M。给工作。
回答by kishore chowdary
I just delete my.ini file and run MySQLInstanceConfig file then mysql is working fine
我只是删除 my.ini 文件并运行 MySQLInstanceConfig 文件然后 mysql 工作正常
