Windows 10企业- MYSQL意外关闭

Question

我已经在机器上安装了Windows10Enterprise64bit，并试图在我的机器上安装Apache、PHP和MySQL，以便用于web开发。简而言之，我一直遇到一个错误"MySQL关闭意外“。我尝试使用WAMP和XAMPP在我的机器上安装，但仍然遇到相同的错误。Apache连接和工作在WAMP和XAMPP上，但是我得到了相同的MySQL错误。

到目前为止，从我所做的所有研究中，请找到我的情况和我尝试过的解决方案的概要。我认为这与Windows 10有关。另外，我在我的MacBook 12英寸上使用bootcamp，所以不确定这是否会增加问题，但我不会这么想。

1. Apache在端口80:433上运行XAMPP和WAMP
2. WAMP - Mysql ->服务，启动/恢复服务是绿色的。当我点击它时，什么都不会发生。我得到了： 8:50:59 AM mysql错误: MySQL意外关闭。 8:50:59 AM mysql --这可能是由于端口阻塞，缺少依赖项， 8:50:59 AM mysql的不正确权限、崩溃或另一种方法的关闭。 上午8:50:59 mysql按“日志”按钮查看错误日志并检查 8:50:59 AM mysql Windows事件查看器获得更多线索 上午8:50:59 mysql如果您需要更多帮助，请复制并发布此文档 上午8:50:59 mysql在论坛上的整个日志窗口
3. 关闭windows防火墙，相同的错误

4.我检查了skype，但实际上它没有安装在我的machine.Also检查控制面板->视图本地服务上，skype没有在命令提示符下运行试用netstat-b，我看不到端口80的任何东西。也尝试了netstat -aon findstr :80，只有TCP 192.168.0.10:49556 23.205.116.42:80建立了1884年。注意:如果端口是一个问题，Apache不应该工作。

1. 我检查了控制面板->视图本地服务没有万维网发布服务。
2. 遵循Xamp-Mysql Shutdown中的解决方案，包括删除ib_logfile1、ib_logfile和ibdata1。除了在my.ini中添加innodb_force_recovery = 1之外，我还得到了一个略有不同的错误，我将其放在下面。

我几乎没有选择了，我要承认，MySQL可能无法在我的windows 10机器上工作。但在我做任何帮助之前，我们将不胜感激。

错误日志：

2015-08-08 08:31:08 7024 [Note] Plugin 'FEDERATED' is disabled.
2015-08-08 08:31:08 18ec InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-08-08 08:31:08 7024 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-08 08:31:08 7024 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-08 08:31:08 7024 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-08-08 08:31:08 7024 [Note] InnoDB: Memory barrier is not used
2015-08-08 08:31:08 7024 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-08-08 08:31:08 7024 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-08 08:31:08 7024 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-08-08 08:31:08 7024 [Note] InnoDB: Completed initialization of buffer pool
2015-08-08 08:31:08 7024 [Note] InnoDB: Highest supported file format is Barracuda.
2015-08-08 08:31:08 18ec  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-08-08 08:31:08 7024 [ERROR] InnoDB: File C:\wamp\mysql\data\ib_logfile0: 'aio read' returned 

错误日志@ innodb_force_recovery =1

2015-08-08 09:32:05 3804 [Note] Plugin 'FEDERATED' is disabled.
2015-08-08 09:32:05 1bf8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-08-08 09:32:05 3804 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-08 09:32:05 3804 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-08 09:32:05 3804 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-08-08 09:32:05 3804 [Note] InnoDB: Memory barrier is not used
2015-08-08 09:32:05 3804 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-08-08 09:32:05 3804 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-08 09:32:05 3804 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-08-08 09:32:05 3804 [Note] InnoDB: Completed initialization of buffer pool
2015-08-08 09:32:05 3804 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2015-08-08 09:32:05 3804 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2015-08-08 09:32:05 3804 [Note] InnoDB: Database physically writes the file full: wait...
2015-08-08 09:32:05 3804 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2015-08-08 09:32:05 3804 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
2015-08-08 09:32:05 1bf8  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-08-08 09:32:05 3804 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile101: 'aio write' returned OS error 187. Cannot continue operation

Answer 1

这个解决方案对我有效。

1. 卸载XAMPP和WAMP
2. 安装WAMP 64位
3. 将以下行添加到my.ini innodb_flush_method=normal中
4. 关闭水浴并重新启动。标志W是绿色和工作。

谢谢：Error 187