MySQL fails to start on XAMPP

 MySQL XAMPP sometimes can't run, fails at start. There is an error like the one below, even though previously it was running smoothly.

Code Error

19:25:23  [mysql] Error: MySQL shutdown unexpectedly.
19:25:23  [mysql] This may be due to a blocked port, missing dependencies,
19:25:23  [mysql] improper privileges, a crash, or a shutdown by another method.
19:25:23  [mysql] Press the Logs button to view error logs and check
19:25:23  [mysql] the Windows Event Viewer for more clues
19:25:23  [mysql] If you need more help, copy and post this
19:25:23  [mysql] entire log window on the forums
19:25:51  [mysql] Attempting to start MySQL app...
19:25:52  [mysql] Status change detected: running
19:25:54  [mysql] Status change detected: stopped

Solution

Open the shell from the XAMPP control panel, then run the command below:

mysqld –-console –-skip-grant-tables –-skip-external-locking

If it is running make sure the table is not damaged. If there is a crash in the following script input table in the terminal shell

mysqlcheck -r --databases mysql --use-frm

Lokasi:

Berbagi :