亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

xampp 不啟動 mysql

xampp 不啟動 mysql

PHP
九州編程 2022-01-08 17:56:36
我使用 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個贊

按照這個步驟,

  1. 退出 Xampp 并導航到xampp/mysql/data目錄

  2. 刪除ibdata1文件

  3. 重新啟動 XAMPP 服務器

或者

  1. 退出 Xampp 并導航到xampp/mysql/data目錄

  2. 刪除ibdata1, ib_logfile0,ib_logfile1,ib_logfile101文件

  3. 重新啟動 XAMPP 服務器


查看完整回答
反對 回復 2022-01-08
?
慕少森

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.



查看完整回答
反對 回復 2022-01-08
  • 2 回答
  • 0 關注
  • 166 瀏覽

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號