CODEWITHSUNDEEP
phpmysqlphpmyadminxamppport
user9592234
user9592234

Reputation:

MySQL shutdown unexpectedly xampp

My apache is running properly but mysql server is showing this error

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.
[mysql] Press the Logs button to view error logs and check
[mysql] the Windows Event Viewer for more clues
[mysql] If you need more help, copy and post this
[mysql] entire log window on the forums

I tried deleting ibdata1, ib_logfile0, ib_logfile1, ib_logfile101 files, but it didn't workout. Help me to solve this problem.

Upvotes: 3

Views: 17464

Answers (3)

Shilpa Vinayaka
Shilpa Vinayaka

Reputation: 31

I faced the same problem.

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

But it didn't work even after copying all files from xampp\mysql\backup, and pasting them inside xampp\mysql\data Or when I deleted ibdata1 file.

So, I went through this link. Free the port number

Stop your Apache module in xampp control panel.

Open command prompt and Run as Administrator

Type “netstat -ano” in the cmd prompt. This will show all the port connections in your network.

netstat -ano

Now find your port number and use it in the find string. In my case, it is 3306. Type “netstat -ano | findstr 3306” in cmd prompt and hit enter.

netstat -ano | findstr 3306

Find the listening id of 3306. In my case, 5224 is my listening id.
Kill that process id with “taskkill /PID 6204 /F“.

taskkill /PID 5224 /F

enter image description here

SUCCESS: The process with PID 5224 has been terminated. will be the output. Restart the xampp Server.

And it worked!

Upvotes: 0

Nuzrath Nalir
Nuzrath Nalir

Reputation: 61

I have faced the same issues today.

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

Solution:

  1. Stop the Apache Service, then

  2. Copy all files from xampp\mysql\backup, and paste all files inside xampp\mysql\data.

  3. Start Apache

...and MySQL is working perfectly.

Upvotes: 5

matri70boss
matri70boss

Reputation: 347

[mysql] Press the Logs button to view error logs and check
[mysql] the Windows Event Viewer for more clues

We could use this information to help you out.

Possibilties:
incorect config - try to restore some known good config
blocked port - quite often its skype(especially older versions of skype), try changing MySQL port

Upvotes: -4

Related Questions