久久久久久久av_日韩在线中文_看一级毛片视频_日本精品二区_成人深夜福利视频_武道仙尊动漫在线观看

Windows 10 Enterprise - MYSQL 意外關閉

數據庫問題 html5模板網
Windows 10 Enterprise - MYSQL shutdown unexpectedly(Windows 10 Enterprise - MYSQL 意外關閉)
本文介紹了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.

  1. Apache 在端口 80:433 上運行，用于 XAMPP 和 WAMP

  2. WAMP - Mysql -> 服務，啟動/恢復服務為綠色.當我點擊它時，什么也沒有發生.我得到的 XAMP:

  1. Apache running on port 80:433 for both XAMPP and WAMP

  2. 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

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

  1. 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

推薦答案

這個解決方案對我有用.

This solution worked for me.

  1. 卸載 XAMPP 和 WAMP
  2. 已安裝 WAMP 64 位
  3. 在 my.ini 中添加以下行innodb_flush_method=正常
  4. 關閉 WAMP 并重新啟動.標志 W 是綠色的，可以正常工作.

感謝:錯誤 187

這篇關于Windows 10 Enterprise - MYSQL 意外關閉的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！

【網站聲明】本站部分內容來源于互聯網,旨在幫助大家更快的解決問題，如果有圖片或者內容侵犯了您的權益，請聯系我們刪除處理，感謝您的支持！

相關文檔推薦

Typeorm Does not return all data(Typeorm 不返回所有數據)
MySQL return extra records when using a long type number to filter varchar type(MySQL在使用長類型數字過濾varchar類型時返回額外記錄)
MySQL Error #1071 - Specified key was too long; max key length is 767 bytes(MySQL 錯誤 #1071 - 指定的鍵太長；最大密鑰長度為 767 字節)
MySQL command-line table column width with utf8(MySQL命令行表列寬與utf8)
Python unicode encoding issue(Python unicode 編碼問題)
Create a MySQL stored function with a dynamic number of arguments(創建一個帶有動態參數數量的 MySQL 存儲函數)
主站蜘蛛池模板： 2022精品国偷自产免费观看 | 久久亚洲国产 | 一区二区在线 | 四虎在线视频 | 九色porny自拍视频 | 欧美一区日韩一区 | 日本国产欧美 | 日韩国产精品一区二区三区 | 精品国产18久久久久久二百 | 免费观看一级特黄欧美大片 | 美女视频h | 日本欧美在线观看视频 | 亚洲一区二区免费 | 国产激情视频在线观看 | 成人精品一区二区三区四区 | 日韩精品一区二区三区免费视频 | 一区二区三区免费在线观看 | 涩涩视频在线观看免费 | 视频一区二区中文字幕 | 成人av在线播放 | 81精品国产乱码久久久久久 | 午夜99 | 国产精品1区2区 | 亚洲不卡在线观看 | 真人女人一级毛片免费播放 | 中文字幕久久精品 | 天天躁日日躁狠狠躁2018小说 | 成人激情免费视频 | 国产视频不卡一区 | 一级毛片,一级毛片 | 婷婷国产一区二区三区 | 亚洲精品成人 | 久久久久久看片 | 亚洲一区二区视频 | 国产欧美精品一区二区三区 | 天天夜碰日日摸日日澡 | 中文字幕在线视频免费视频 | 国产一级特黄真人毛片 | 欧美一区二区三区免费电影 | 欧美中文字幕一区二区三区亚洲 | 亚洲视频免费在线看 |