xampp中的mysql在五秒内启动和停止 [英] mysql in xampp starts and stops in five seconds

问题描述

我在 Windows XP 中安装了 xampp.我能够启动 apache 和 tomcat.但是当我启动 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.

所以，我无法使用 PHPMyAdmin.

So, I am not able to work with PHPMyAdmin.

我检查了 xampp/mysql/bin 中的 mysql_error 文件，发现以下内容.

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:xamppmysqldataibdata1 did not exist:
InnoDB: a new database to be created!
120320 11:48:45  InnoDB: Setting file C:xamppmysqldataibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120320 11:48:45  InnoDB: Log file C:xamppmysqldataib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:xamppmysqldataib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
120320 11:48:45  InnoDB: Log file C:xamppmysqldataib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:xamppmysqldataib_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] mysqlinmysqld.exe: ready for connections.
Version: '5.5.16'  socket: ''  port: 3306  MySQL Community Server (GPL)

我正在使用 xampp 1.7.7

请帮忙...

推荐答案

这对我有用，

1. 退出 XAMPP

1. quit the XAMPP

剪切C:xamppmysqlackup中的所有文件

粘贴和替换C:xamppmysqldata中的文件

以管理员身份运行 XAMPP

这篇关于xampp中的mysql在五秒内启动和停止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！