Error: MySQL shutdown unexpectedly.

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

Error: MySQL shutdown unexpectedly.

Postby eilman » 30. March 2023 04:10

Hi, I've already checked the services windows on the task manager and found nothing on port 3306. I've try reinstall xampp couple of time and still the same error occurred. Really could use some help to resolve this problem since I need mysql for my studies. Below is the error logs of mysql. Thank you in advance :)

2023-03-30 10:55:41 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2023-03-30 10:55:41 0 [ERROR] Aborting
2023-03-30 11:07:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-03-30 11:07:11 0 [Note] InnoDB: Uses event mutexes
2023-03-30 11:07:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-30 11:07:11 0 [Note] InnoDB: Number of pools: 1
2023-03-30 11:07:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-03-30 11:07:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-03-30 11:07:11 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-30 11:07:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-03-30 11:07:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-03-30 11:07:12 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-03-30 11:07:12 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-03-30 11:07:12 0 [Note] InnoDB: Waiting for purge to start
2023-03-30 11:07:12 0 [Note] InnoDB: 10.4.27 started; log sequence number 300315; transaction id 170
2023-03-30 11:07:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-03-30 11:07:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-30 11:07:12 0 [Note] Server socket created on IP: '::'.
2023-03-30 11:07:12 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
eilman
 
Posts: 1
Joined: 30. March 2023 03:59
XAMPP version: 8.2.0
Operating System: Windows 10

Re: Error: MySQL shutdown unexpectedly.

Postby FeralReason » 30. March 2023 13:53

Same thing here. Repeatedly deleted & reinstalled 8.2 but had same result - sometimes after just a day or two. Currently playing with Docker as alternative but (the learning curve is steeper) and I'd really rather have a stable version of XAMPP. Haven't tried the 8.1 version but it may be worth a trial.
FeralReason
 
Posts: 19
Joined: 16. April 2009 20:42

Re: Error: MySQL shutdown unexpectedly.

Postby Froosh » 30. March 2023 15:59

Not sure how one would determine this using Services from Windows Task Manager, as I see no option there to see ports being used by a service. Might just be that I never looked in the correct place for that.

The best way I know to see what applications are using ports is to run the command prompt as an administrator and execute "netstat -ab". That shows which applications have open ports on the system.
User avatar
Froosh
 
Posts: 138
Joined: 27. March 2022 17:56
XAMPP version: 8.2.0
Operating System: Windows 11 Pro


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 116 guests