Page 1 of 1

Error: MySQL shutdown unexpectedly.

PostPosted: 30. March 2023 04:10
by eilman
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.

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 30. March 2023 13:53
by FeralReason
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.

Re: Error: MySQL shutdown unexpectedly.

PostPosted: 30. March 2023 15:59
by Froosh
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.