xampp的mysql启动后自动关闭,xampp中的mysql在五秒钟内启动和停止

I installed xampp in windows XP. I am able to start apache and tomcat. But when I start mysql, it gets started but stops after five seconds.

So, I am not able to work with PHPMyAdmin.

I checked the mysql_error file inside xampp/mysql/bin and the following was present.

120320 11:48:44 [Note] Plugin 'FEDERATED' is disabled.

120320 11:48:44 InnoDB: The InnoDB memory heap is disabled

120320 11:48:44 InnoDB: Mutexes and rw_locks use Windows interlocked functions

120320 11:48:44 InnoDB: Compressed tables use zlib 1.2.3

120320 11:48:45 InnoDB: Initializing buffer pool, size = 16.0M

120320 11:48:45 InnoDB: Completed initialization of buffer pool

InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:

InnoDB: a new database to be created!

120320 11:48:45 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

120320 11:48:45 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB

InnoDB: Database physically writes the file full: wait...

120320 11:48:45 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: 127 rollback segment(s) active.

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

120320 11:48:48 InnoDB: Waiting for the background threads to start

120320 11:48:49 InnoDB: 1.1.8 started; log sequence number 0

120320 11:48:52 [Note] Event Scheduler: Loaded 0 events

120320 11:48:52 [Note] mysql\bin\mysqld.exe: ready for connections.

Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)

I am using xampp 1.7.7

please help...

解决方案

i had the same problem and i have found a temporary solution by going to the installation folder

xampp->mysql->bin-> mysqld.exe file

running the mysqld.exe file

my xampp mysql service restarted successfully