Xampp cant run MySQL in localhost! - " Error: MySQL shutdown unexpectedly."

Question

Today i tried to run MySQL in localhost ,but shutdown immediately.

Error: MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies, improper privileges, a crash, or a shutdown by another method. Press the Logs button to view error logs and check the Windows Event Viewer for more clues If you need more help, copy and post this entire log window on the forums

I really cant find the issue.

Open MySQL data folder and delete files starting with ib

Shahlin Ibrahim
– Shahlin Ibrahim

2020-04-30 21:21:53 +00:00
Commented Apr 30, 2020 at 21:21 — Shahlin Ibrahim
– Shahlin Ibrahim, Commented Apr 30, 2020 at 21:21

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

This error is occurring because the default port that MySQL uses(3306) has been already taken by another task. in that case you can kill the running PID and start it again.

Solution 1:

taskkill /pid <port>

Steps:

Go to netstat and find the PID for MySQL.
Kill the PID in the command prompt using the command that is mentioned above.
Then start mysql again.

Solution 2:

exit Xampp server
go to your C:\xampp\mysql\data directory
delete the ibdata1 file
restart xampp server

I hope this will solve your issue.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Apr 30, 2020 at 20:36

Hirumina

7381 gold badge9 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Xampp cant run MySQL in localhost! - " Error: MySQL shutdown unexpectedly."

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related