MySQL fail after start

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL fail after start

Postby bryantmilan » 21. April 2020 13:51

Hi, I am using XAMPP for two months and it worked perfectly until today. As usual I started Apache and it's working and when I start MySQL it starts and after one minute turn off with "Error: MySQL shutdown unexpectedly." I tried with chaning port from 3306 to 3307 in .ini file and in config but nothing. I saw there is new update 7.4.4 and I am using 7.4.2, should I update? I just worry about MySQL databases because can't access phpmyadmin to export data..
Here is the log:

Code: Select all
2020-04-21 14:47:34 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 14:47:34 0 [Note] InnoDB: Uses event mutexes
2020-04-21 14:47:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 14:47:34 0 [Note] InnoDB: Number of pools: 1
2020-04-21 14:47:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 14:47:34 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 14:47:34 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 14:47:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 14:47:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 14:47:35 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 14:47:35 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 14:47:35 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 14:47:35 0 [Note] InnoDB: 10.4.11 started; log sequence number 3616995; transaction id 2608
2020-04-21 14:47:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 14:47:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 14:47:35 0 [Note] Server socket created on IP: '::'.
2020-04-21 14:47:35 0 [Note] InnoDB: Buffer pool(s) load completed at 200421 14:47:35

Thank you very much in advance,
Milan.
bryantmilan
 
Posts: 3
Joined: 21. April 2020 09:56
XAMPP version: 7.4.4
Operating System: Windows 10 Pro

Re: MySQL fail after start

Postby bryantmilan » 22. April 2020 09:09

Solved! I have uninstalled 7.4.2 version and installed fresh new 7.4.4 version and now MySQL is working.
Lost all MySQL databases because I am beginner and tried with copy-paste system but I think I could do export with cmd, there was not much data luckily.
Now I have different problem, when I go on minimized icon on taskbar and quit XAMPP I get error, screenshots below.

Image

Image

Anyone who knows how to solve this problem?

Thank you in advance,
Milan.
bryantmilan
 
Posts: 3
Joined: 21. April 2020 09:56
XAMPP version: 7.4.4
Operating System: Windows 10 Pro

Re: MySQL fail after start

Postby Altrea » 22. April 2020 09:36

Start the control panel with enhanced administrator rights (rightclick -> run as Administrator).
The issue is reported and will hopefully get fixed in one of the next XAMPP releases.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11934
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 159 guests