Page 1 of 1

MySQL shutdown unexpectedly

PostPosted: 20. December 2013 11:20
by joju
hello,
I install Xampp, Apache module is working, but MySQL don't.

11:05:46 [mysql] Attempting to start MySQL app...
11:05:47 [mysql] Status change detected: running
11:05:50 [mysql] Status change detected: stopped
11:05:50 [mysql] Error: MySQL shutdown unexpectedly.
11:05:50 [mysql] This may be due to a blocked port, missing dependencies,
11:05:50 [mysql] improper privileges, a crash, or a shutdown by another method.
11:05:50 [mysql] Press the Logs button to view error logs and check
11:05:50 [mysql] the Windows Event Viewer for more clues
11:05:50 [mysql] If you need more help, copy and post this
11:05:50 [mysql] entire log window on the forums
11:06:27 [main] Executing "services.msc"

in Log window is something like that:
131220 11:05:47 [Note] Plugin 'FEDERATED' is disabled.
131220 11:05:47 InnoDB: The InnoDB memory heap is disabled
131220 11:05:47 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131220 11:05:47 InnoDB: Compressed tables use zlib 1.2.3
131220 11:05:47 InnoDB: Initializing buffer pool, size = 16.0M
131220 11:05:47 InnoDB: Completed initialization of buffer pool
131220 11:05:47 InnoDB: highest supported file format is Barracuda.
131220 11:05:47 InnoDB: Waiting for the background threads to start
131220 11:05:48 InnoDB: 5.5.32 started; log sequence number 1595675
131220 11:05:48 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131220 11:05:49 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131220 11:05:49 [Note] Server socket created on IP: '0.0.0.0'.
131220 11:05:50 [ERROR] Event Scheduler: Failed to open table mysql.event
131220 11:05:50 [ERROR] Event Scheduler: Error while loading from disk.
131220 11:05:50 [Note] Event Scheduler: Purging the queue. 0 events
131220 11:05:50 [ERROR] Aborting

131220 11:05:50 InnoDB: Starting shutdown...
131220 11:05:50 InnoDB: Shutdown completed; log sequence number 1595675
131220 11:05:50 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete



I don't know what to do.
please help :)

Re: MySQL shutdown unexpectedly

PostPosted: 20. December 2013 13:44
by JJ_Tagy
Not enough info to troubleshoot. As you have at the top, you need the entire log window contents. Perhaps a description of how you installed (i.e. fresh install or upgrade, modifications made, etc)

Re: MySQL shutdown unexpectedly

PostPosted: 20. December 2013 14:56
by joju
I reinstal Xampp, and now it dosn't work at all....

14:55:15 [main] Initializing Control Panel
14:55:15 [main] Windows Version: Windows 7 Home Premium SP1 64-bit
14:55:15 [main] XAMPP Version: 1.8.3
14:55:15 [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
14:55:15 [main] You are not running with administrator rights! This will work for
14:55:15 [main] most application stuff but whenever you do something with services
14:55:15 [main] there will be a security dialogue or things will break! So think
14:55:15 [main] about running this application with administrator rights!
14:55:15 [main] XAMPP Installation Directory: "c:\program files (x86)\xampp\"
14:55:15 [main] WARNING: Your install directory contains spaces. This may break programs/scripts
14:55:15 [main] WARNING: Your install directory contains special characters. This may break programs/scripts
14:55:15 [main] Checking for prerequisites
14:55:16 [main] All prerequisites found
14:55:16 [main] Initializing Modules
14:55:16 [main] Starting Check-Timer
14:55:16 [main] Control Panel Ready
14:55:36 [Apache] Attempting to start Apache app...
14:55:36 [Apache] Status change detected: running
14:55:37 [Apache] Status change detected: stopped
14:55:37 [Apache] Error: Apache shutdown unexpectedly.
14:55:37 [Apache] This may be due to a blocked port, missing dependencies,
14:55:37 [Apache] improper privileges, a crash, or a shutdown by another method.
14:55:37 [Apache] Press the Logs button to view error logs and check
14:55:37 [Apache] the Windows Event Viewer for more clues
14:55:37 [Apache] If you need more help, copy and post this
14:55:37 [Apache] entire log window on the forums
14:55:43 [mysql] Attempting to start MySQL app...
14:55:43 [mysql] Status change detected: running
14:55:43 [mysql] Status change detected: stopped
14:55:43 [mysql] Error: MySQL shutdown unexpectedly.
14:55:43 [mysql] This may be due to a blocked port, missing dependencies,
14:55:43 [mysql] improper privileges, a crash, or a shutdown by another method.
14:55:43 [mysql] Press the Logs button to view error logs and check
14:55:44 [mysql] the Windows Event Viewer for more clues
14:55:44 [mysql] If you need more help, copy and post this
14:55:44 [mysql] entire log window on the forums

Re: MySQL shutdown unexpectedly

PostPosted: 20. December 2013 16:07
by joju
ok....
reinstal older version...... and now it's working :)

wrrrr...... it's not for me :) I'm too nervous