• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

MySQL shutdown immediately after starting

Yamo

New Member
Joined
Jun 8, 2008
Messages
77
Reaction score
2
Sometimes when I startup my computer and I am trying to activate Apache and MySQL via Xampp to run my server, MySQL shuts down immediately after starting.

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

I tried several things to fix this problem like:
- Restarting my computer (several times)
- Uncheck the 'use port 80 and 443 as alternatives for incoming connections' at Skype.
- Shutdown Skype
- Change the port of MySQL in my.ini
- Trying to find (and kill) another running process using port 3306
- Add the line 'innodb_force_recovery = 4' in my.ini
- Delete the file 'ibdata1' in xampp\mysql\data
- Install MySQL as a Windows Service prior to starting it.

None of those seems to be a fix for the problem. Any other ideas?

Thank you.
 
Last edited:
Works, I guess ^^.
I hope it will keep working.
Any way I can import the db from my server from xampp to wamp w/o being able to start mysql on xampp?

I never had problems with wamp, it works well and fits all my demand :)
I think it will be hard to import the DB without starting xampp, I doubt their clean saved somewhere on you computer, thats what the mysql is for, tho I am not a pro to mysql :p
 
Back
Top