Computer Science/DataBase

mysql shutdown unexpectedly 에러 해결하기

kimdozzi 2023. 7. 29. 17:56

Error: MySQL shutdown unexpectedly

[mysql] This may be due to a blocked port, missing dependencies,

[mysql] improper privileges, a crash, or a shutdown by another method.

 

 

Instead, first try using the MySQL backup folder which is included with XAMPP. So do next steps:

  1. Rename folder mysql/data to mysql/data_old
  2. Make a copy of mysql/backup folder and name it as mysql/data
  3. Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema, and phpmyadmin folders)
  4. Copy mysql/data_old/ibdata1 file into mysql/data folder
  5. Start MySQL from XAMPP control panel

 

출처 : 

 

https://stackoverflow.com/questions/18022809/how-to-solve-error-mysql-shutdown-unexpectedly

 

How to solve "Error: MySQL shutdown unexpectedly"?

When I open XAMPP and click start MySQL button and it gives me an error. I had started it just before, but now it isn't working. 12:19:12 PM [mysql] Attempting to start MySQL app... 12:19:12 ...

stackoverflow.com