Mysql in xampp starts and stops after five seconds

Question

I installed xampp on Windows XP. I can run apache and tomcat. But when I start mysql, it starts, but stops after five seconds.

So, I can not 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...

Answer 1

I had the same problem and found a workaround by going to the installation folder

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

running mysqld.exe file

my mysql xampp service rebooted successfully

Answer 2

I'm not sure that this will work for your case either, but it is certainly for me, and I have not yet encountered the answer here.

go to xampp / mysql / bin / my.ini

add the following line:

 innodb_force_recovery = 1 

(I think something> 0 works here, as well ... it might be convenient to back up the file just to be safe.)

Now you can successfully start your mySQL service.

Answer 3

This is an alternative solution instead of solving the above problem. I think you used the Windows installer for xampp, instead download the zip file and save it under c: \ xampp. Use this link to download in zip format.

http://www.apachefriends.org/download.php?xampp-win32-1.7.7-VC9.zip

If you feel that the zip file format is huge. Use the 7zip file format.

http://www.apachefriends.org/download.php?xampp-win32-1.7.7-VC9.7z

I used to have the same problem, it was solved in this way.

Answer 4

Did you accidentally update your previous installation and then copy / paste the old "htdocs" and "mysql data" files into the update files?

Launched the same problem that I decided to remove and then install again. Copying only my Htdocs and then restoring my database ... Pain, but since I am only in development, and using Symfony2 to restore my database with lights was pretty painless.

Hope this helps.

Arc.

Answer 5

I had a similar problem caused by the TCP port needed for one for services that are already in use by another application. In my case, it was Skype using ports 80 and 443 as drop.

You can check if any of the required TCP ports is being used by another application by doing the following at a command prompt:

 c:>netstat /a 

The connection with the violation will be indicated as “LISTENING” in the STATE status column. Then you decide which application uses the port. There is a good tool called portmon for this.

You will need ports 80, 3360 ... (can anyone expand on this?)

Answer 6

Here's how I solved it:

• xampp control panel> config> service and port settings> apache> mainport> 80 (default) change to 81.

• open xampp> apache> cnonf> httpd.conf

3 search for ServerName localhost: 80 change to ServerName localhost: 81 do a search Listen 80 change to Listen 81

4. Launch Xampp> apache

5. open http: // localhost: 81 / phpmyadmin /

whoaa his working

Answer 7

It worked for me

• exit XAMPP

• cut all files in C: \ xampp \ mysql \ backup

• insert and replace files in C: \ xampp \ mysql \ data strong>

• run as XAMPP administrator