求xampp中mysql啟動失敗解決方法,在線等(不刪除ibdata1 文件)
問題描述
錯誤提示:11:35:17 [mysql] Error: MySQL shutdown unexpectedly.11:35:17 [mysql] This may be due to a blocked port, missing dependencies, 11:35:17 [mysql] improper privileges, a crash, or a shutdown by another method.11:35:17 [mysql] Press the Logs button to view error logs and check11:35:17 [mysql] the Windows Event Viewer for more clues11:35:17 [mysql] If you need more help, copy and post this11:35:17 [mysql] entire log window on the forums自己找的解決方案:1.找到本地磁盤D:存放xampp的文件夾,點擊打開文件夾2.找到Mysql文件夾,點擊打開3.找到data文件夾,點擊打開4.找到 ibdata1 這個文件,并刪除它但是這樣做的話自己的數(shù)據(jù)表就丟失了,所以想著不刪除ibdata1那個文件的話怎么解決這問題呢?溫柔一點
問題解答
回答1:去找MySQL的日志,看看啟動失敗的具體原因
或者根據(jù)你提供的這些一條一條的檢查,看看那個不符合
