午夜精品国产,亚洲精品一区二,日韩大片免费观看

本文介紹了Windows 10 Enterprise - MYSQL 意外關閉的處理方法，對大家解決問題具有一定的參考價值，需要的朋友們下面隨著小編來一起學習吧！

問題描述

限時送ChatGPT賬號..

我已經在機器上安裝了 Windows 10 Enterprise 64bit 并嘗試在我的機器上安裝 Apache、PHP 和 MySQL 以用于 Web 開發.簡而言之，我一直遇到錯誤MySQL 意外關閉".我嘗試在我的機器上使用 WAMP 和 XAMPP 進行安裝，但仍然遇到相同的錯誤.Apache 連接并在 WAMP 和 XAMPP 上工作，但是我收到相同的 MySQL 錯誤.

I've installed Windows 10 Enterprise 64bit on machine and attempting to install Apache, PHP and MySQL on my machine to use for web development. In short I keep running into an error "MySQL shutdown unexpectedly". I've attempted to install using WAMP and XAMPP on my machine and still run into the same error. Apache connects and works on both WAMP and XAMPP however I get the same MySQL error.

到目前為止，在我所做的所有研究中，請找到我的情況和我嘗試過的解決方案的概要.我認為這與 Windows 10 有關.另外，作為旁注，我在 12 英寸 MacBook 上使用訓練營，因此不確定這是否會增加問題，但我不會這么認為.

So far from all the research I've done please find a synopsis of my situation and the solutions I've tried. I'm thinking this is to do with Windows 10. Also as a side note I'm using bootcamp on my MacBook 12 inch so not sure if this adding to the problem but I would not have thought so.

Apache 在端口 80:433 上運行，用于 XAMPP 和 WAMP
WAMP - Mysql -> 服務，啟動/恢復服務為綠色.當我點擊它時，什么也沒有發生.我得到的 XAMP:

Apache running on port 80:433 for both XAMPP and WAMP
WAMP - Mysql -> service, start/resume service is green. When I click on it nothing happens. XAMP I get:

8:50:59 AM [mysql] 錯誤:MySQL 意外關閉.

8:50:59 AM [mysql] Error: MySQL shutdown unexpectedly.

上午 8:50:59 [mysql] 這可能是由于端口阻塞、缺少依賴項，

8:50:59 AM [mysql] This may be due to a blocked port, missing dependencies,

8:50:59 AM [mysql] 權限不當、崩潰或通過其他方法關閉.

8:50:59 AM [mysql] improper privileges, a crash, or a shutdown by another method.

8:50:59 AM [mysql] 按日志按鈕查看錯誤日志并檢查

8:50:59 AM [mysql] Press the Logs button to view error logs and check

8:50:59 AM [mysql] Windows 事件查看器獲取更多線索

8:50:59 AM [mysql] the Windows Event Viewer for more clues

8:50:59 AM [mysql] 如果您需要更多幫助，請復制并發布此內容

8:50:59 AM [mysql] If you need more help, copy and post this

8:50:59 AM [mysql] 論壇上的整個日志窗口

8:50:59 AM [mysql] entire log window on the forums

關閉windows防火墻，同樣的錯誤

Turned off windows firewall, same errors

4.我已經檢查過Skype，但它實際上沒有安裝在我的機器上.還檢查了控制面板->查看本地服務，Skype不存在，也沒有在命令提示符下運行嘗試過netstat-b，但我不能查看端口 80 的任何內容.還嘗試過 netstat -aon |findstr :80, only TCP 192.168.0.10:49556 23.205.116.42:80 ESTABLISHED 1884. 注意:如果端口是一個問題 Apache 不應該工作

4.I've checked for skype but it is actually not installed on my machine.Also checked control panel -> view local services, skype is not there nor running Tried netstat-b in the command prompt and I can't see anything with port 80. Also tried netstat -aon | findstr :80, only TCP 192.168.0.10:49556 23.205.116.42:80 ESTABLISHED 1884. Note: If the port was an issue Apache should not be working

我檢查了控制面板 -> 查看本地服務，沒有萬維網發布服務.

I checked the control panel -> view local services there is no World Wide Web Publishing Service.

遵循 Xamp-Mysql Shutdown 中的解決方案，其中包括刪除 ib_logfile1、ib_logfile 和ibdata1.以及將 my.ini 附加到 innodb_force_recovery = 1.我得到了一個稍微不同的錯誤，我把它放在下面.

Followed solution in Xamp-Mysql Shutdown which included deleting ib_logfile1, ib_logfile and ibdata1. As well as appending my.ini with innodb_force_recovery = 1. I get a slightly different error which I put below.

我幾乎別無選擇，即將接受 MySQL 可能無法在我的 Windows 10 機器上運行的事實.但在我提供任何幫助之前，我們將不勝感激.

I'm pretty much out of options and about to give into the fact that MySQL may not work on my windows 10 machine. But before I do any help would be appreciated.

錯誤日志:

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

Error Log @ 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

pbootcms网站模板|日韩1区2区|织梦模板||网站源码|日韩1区2区|jquery建站特效-html5模板网

Windows 10 Enterprise - MYSQL 意外關閉

問題描述

推薦答案

相關文檔推薦