Apache Friends Support Forum

Well guys, I'm using xampp for mysql. I'm installed it and started mysql. After I'm closed xampp and re-open it and when I'm tried to start mysql I see that:

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

Help me please

Eren07 wrote:16:30:26 [mysql] Press the Logs button to view error logs and check
16:30:26 [mysql] the Windows Event Viewer for more clues
16:30:26 [mysql] If you need more help, copy and post this
16:30:26 [mysql] entire log window on the forums

140708 18:40:56 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
140708 18:40:56 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140708 18:40:56 InnoDB: The InnoDB memory heap is disabled
140708 18:40:56 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140708 18:40:56 InnoDB: Compressed tables use zlib 1.2.3
140708 18:40:56 InnoDB: Initializing buffer pool, size = 16.0M
140708 18:40:56 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
140708 18:40:56 InnoDB: Could not open or create data files.
140708 18:40:56 InnoDB: If you tried to add new data files, and it failed here,
140708 18:40:56 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140708 18:40:56 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140708 18:40:56 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140708 18:40:56 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140708 18:40:56 InnoDB: remove old data files which contain your precious data!
140708 18:40:56 [ERROR] Plugin 'InnoDB' init function returned error.
140708 18:40:56 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140708 18:40:56 [ERROR] Unknown/unsupported storage engine: InnoDB
140708 18:40:56 [ERROR] Aborting

140708 18:40:56 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140708 18:41:03 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
140708 18:41:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140708 18:41:03 InnoDB: The InnoDB memory heap is disabled
140708 18:41:03 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140708 18:41:03 InnoDB: Compressed tables use zlib 1.2.3
140708 18:41:03 InnoDB: Initializing buffer pool, size = 16.0M
140708 18:41:03 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
140708 18:41:03 InnoDB: Could not open or create data files.
140708 18:41:03 InnoDB: If you tried to add new data files, and it failed here,
140708 18:41:03 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140708 18:41:03 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140708 18:41:03 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140708 18:41:03 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140708 18:41:03 InnoDB: remove old data files which contain your precious data!
140708 18:41:03 [ERROR] Plugin 'InnoDB' init function returned error.
140708 18:41:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140708 18:41:03 [ERROR] Unknown/unsupported storage engine: InnoDB
140708 18:41:03 [ERROR] Aborting

140708 18:41:03 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140708 18:41:08 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
140708 18:41:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140708 18:41:08 InnoDB: The InnoDB memory heap is disabled
140708 18:41:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140708 18:41:08 InnoDB: Compressed tables use zlib 1.2.3
140708 18:41:08 InnoDB: Initializing buffer pool, size = 16.0M
140708 18:41:08 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
140708 18:41:08 InnoDB: Could not open or create data files.
140708 18:41:08 InnoDB: If you tried to add new data files, and it failed here,
140708 18:41:08 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140708 18:41:08 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140708 18:41:08 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140708 18:41:08 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140708 18:41:08 InnoDB: remove old data files which contain your precious data!
140708 18:41:08 [ERROR] Plugin 'InnoDB' init function returned error.
140708 18:41:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140708 18:41:08 [ERROR] Unknown/unsupported storage engine: InnoDB
140708 18:41:08 [ERROR] Aborting

140708 18:41:08 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

This way please: viewtopic.php?f=16&t=67577&p=232773#p232773

What should I do there?

read it carefully?!

I can't find my answer there, can you explain it here please?

If you don't find the answer there, i am unable to explain it to you, sorry.

I have written this Bug reports which took some of time.
All information are in it including two possible workaround explained step by step.
If that is not easy enough for you to follow, nobody can help you here.