我使用 xampp-windows-x64。以前我可以在 xampp 中打開 mysql。但經過我重新啟動我的筆記本電腦,我無法打開mysql的xampp控制。這個日志:11:00:23 [mysql] Error: MySQL shutdown unexpectedly.11:00:23 [mysql] This may be due to a blocked port, missing dependencies, 11:00:23 [mysql] improper privileges, a crash, or a shutdown by another method.11:00:23 [mysql] Press the Logs button to view error logs and check11:00:23 [mysql] the Windows Event Viewer for more clues11:00:23 [mysql] If you need more help, copy and post this11:00:23 [mysql] entire log window on the forums和 mysql_error.log2019-09-13 11:16:14 0 [Note] InnoDB: Uses event mutexes2019-09-13 11:16:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.112019-09-13 11:16:14 0 [Note] InnoDB: Number of pools: 12019-09-13 11:16:14 0 [Note] InnoDB: Using SSE2 crc32 instructions2019-09-13 11:16:14 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M2019-09-13 11:16:14 0 [Note] InnoDB: Completed initialization of buffer pool2019-09-13 11:16:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.2019-09-13 11:16:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables2019-09-13 11:16:15 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...2019-09-13 11:16:15 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.2019-09-13 11:16:15 0 [Note] InnoDB: Waiting for purge to start2019-09-13 11:16:15 0 [Note] InnoDB: 10.3.16 started; log sequence number 19023759; transaction id 150372019-09-13 11:16:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool2019-09-13 11:16:15 0 [Note] InnoDB: Buffer pool(s) load completed at 190913 11:16:152019-09-13 11:16:15 0 [Note] Plugin 'FEEDBACK' is disabled.2019-09-13 11:16:15 0 [Note] Server socket created on IP: '::'.如何從 xampp 啟動 mysql?
2 回答

慕斯709654
TA貢獻1840條經驗 獲得超5個贊
按照這個步驟,
退出 Xampp 并導航到
xampp/mysql/data
目錄刪除
ibdata1
文件重新啟動 XAMPP 服務器
或者
退出 Xampp 并導航到
xampp/mysql/data
目錄刪除
ibdata1, ib_logfile0,ib_logfile1,ib_logfile101
文件重新啟動 XAMPP 服務器

慕少森
TA貢獻2019條經驗 獲得超9個贊
xampp無法啟動MySQL服務的原因有很多。手動啟動 MySQL 服務
End Task mysqld.exe
1)Open Task Manager** > Progresses Tab > right click 'mysqld.exe' > end task
2)Open your services.msc by Run (press 'Window + R') > services.msc or 0n your XAMPP ControlPanel, click 'Services' button. Find 'MySQL' service, right click and run it.
- 2 回答
- 0 關注
- 166 瀏覽
添加回答
舉報
0/150
提交
取消