My question is in my Xammp Error: MySQL shutdown unexpectedly.

Question

2025-01-22 14:20:12 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 22688

2025-01-22 14:20:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-01-22 14:20:12 0 [Note] InnoDB: Uses event mutexes

2025-01-22 14:20:12 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-01-22 14:20:12 0 [Note] InnoDB: Number of pools: 1

2025-01-22 14:20:12 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-01-22 14:20:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-01-22 14:20:12 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-22 14:20:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288

2025-01-22 14:20:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2025-01-22 14:20:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2025-01-22 14:20:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2025-01-22 14:20:12 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2025-01-22 14:20:12 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2025-01-22 14:20:12 0 [Note] InnoDB: Waiting for purge to start

2025-01-22 14:20:12 0 [Note] InnoDB: 10.4.32 started; log sequence number 300297; transaction id 170

2025-01-22 14:20:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2025-01-22 14:20:12 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-01-22 14:20:12 0 [Note] Server socket created on IP: '::'.

2025-01-22 14:20:12 0 [Note] InnoDB: Buffer pool(s) load completed at 250122 14:20:12

2025-01-22 14:20: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.

2025-01-22 14:20:12 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2025-01-22 14:20:12 0 [ERROR] Aborting

2025-01-22 14:20:25 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 24788

2025-01-22 14:20:25 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-01-22 14:20:25 0 [Note] InnoDB: Uses event mutexes

2025-01-22 14:20:25 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-01-22 14:20:25 0 [Note] InnoDB: Number of pools: 1

2025-01-22 14:20:25 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-01-22 14:20:25 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-01-22 14:20:25 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-22 14:20:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2025-01-22 14:20:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2025-01-22 14:20:25 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2025-01-22 14:20:25 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2025-01-22 14:20:25 0 [Note] InnoDB: Waiting for purge to start

2025-01-22 14:20:25 0 [Note] InnoDB: 10.4.32 started; log sequence number 300306; transaction id 170

2025-01-22 14:20:25 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2025-01-22 14:20:25 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-01-22 14:20:25 0 [Note] InnoDB: Buffer pool(s) load completed at 250122 14:20:25

2025-01-22 14:20:25 0 [Note] Server socket created on IP: '::'.

2025-01-22 14:20:25 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.

2025-01-22 14:20:25 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2025-01-22 14:20:25 0 [ERROR] Aborting

2025-01-22 14:20:39 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 12480

2025-01-22 14:20:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-01-22 14:20:39 0 [Note] InnoDB: Uses event mutexes

2025-01-22 14:20:39 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-01-22 14:20:39 0 [Note] InnoDB: Number of pools: 1

2025-01-22 14:20:39 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-01-22 14:20:39 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-01-22 14:20:39 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-22 14:20:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2025-01-22 14:20:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2025-01-22 14:20:40 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2025-01-22 14:20:40 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2025-01-22 14:20:40 0 [Note] InnoDB: Waiting for purge to start

2025-01-22 14:20:40 0 [Note] InnoDB: 10.4.32 started; log sequence number 300315; transaction id 170

2025-01-22 14:20:40 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2025-01-22 14:20:40 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-01-22 14:20:40 0 [Note] InnoDB: Buffer pool(s) load completed at 250122 14:20:40

2025-01-22 14:20:40 0 [Note] Server socket created on IP: '::'.

2025-01-22 14:20:40 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.

2025-01-22 14:20:40 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2025-01-22 14:20:40 0 [ERROR] Aborting

2025-01-22 14:40:35 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 22236

2025-01-22 14:40:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-01-22 14:40:35 0 [Note] InnoDB: Uses event mutexes

2025-01-22 14:40:35 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-01-22 14:40:35 0 [Note] InnoDB: Number of pools: 1

2025-01-22 14:40:35 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-01-22 14:40:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-01-22 14:40:35 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-22 14:40:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2025-01-22 14:40:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2025-01-22 14:40:35 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2025-01-22 14:40:35 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2025-01-22 14:40:35 0 [Note] InnoDB: Waiting for purge to start

2025-01-22 14:40:35 0 [Note] InnoDB: 10.4.32 started; log sequence number 300324; transaction id 170

2025-01-22 14:40:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2025-01-22 14:40:35 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-01-22 14:40:35 0 [Note] InnoDB: Buffer pool(s) load completed at 250122 14:40:35

2025-01-22 14:40:35 0 [Note] Server socket created on IP: '::'.

2025-01-22 14:40:35 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.

2025-01-22 14:40:35 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2025-01-22 14:40:35 0 [ERROR] Aborting

2025-01-22 14:41:26 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 21924

2025-01-22 14:41:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-01-22 14:41:26 0 [Note] InnoDB: Uses event mutexes

2025-01-22 14:41:26 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-01-22 14:41:26 0 [Note] InnoDB: Number of pools: 1

2025-01-22 14:41:26 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-01-22 14:41:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-01-22 14:41:26 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-22 14:41:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2025-01-22 14:41:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2025-01-22 14:41:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2025-01-22 14:41:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2025-01-22 14:41:26 0 [Note] InnoDB: Waiting for purge to start

2025-01-22 14:41:26 0 [Note] InnoDB: 10.4.32 started; log sequence number 300333; transaction id 170

2025-01-22 14:41:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2025-01-22 14:41:26 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-01-22 14:41:26 0 [Note] InnoDB: Buffer pool(s) load completed at 250122 14:41:26

2025-01-22 14:41:26 0 [Note] Server socket created on IP: '::'.

2025-01-22 14:41:26 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.

2025-01-22 14:41:26 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2025-01-22 14:41:26 0 [ERROR] Aborting

2025-01-22 15:02:43 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 17808

2025-01-22 15:02:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-01-22 15:02:43 0 [Note] InnoDB: Uses event mutexes

2025-01-22 15:02:43 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-01-22 15:02:43 0 [Note] InnoDB: Number of pools: 1

2025-01-22 15:02:43 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-01-22 15:02:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-01-22 15:02:43 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-22 15:02:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2025-01-22 15:02:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2025-01-22 15:02:43 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2025-01-22 15:02:43 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2025-01-22 15:02:43 0 [Note] InnoDB: Waiting for purge to start

2025-01-22 15:02:44 0 [Note] InnoDB: 10.4.32 started; log sequence number 300342; transaction id 170

2025-01-22 15:02:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2025-01-22 15:02:44 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-01-22 15:02:44 0 [Note] InnoDB: Buffer pool(s) load completed at 250122 15:02:44

2025-01-22 15:02:44 0 [Note] Server socket created on IP: '::'.

2025-01-22 15:02:44 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.

2025-01-22 15:02:44 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2025-01-22 15:02:44 0 [ERROR] Aborting

2025-01-22 15:02:58 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 21888

2025-01-22 15:02:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-01-22 15:02:58 0 [Note] InnoDB: Uses event mutexes

2025-01-22 15:02:58 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-01-22 15:02:58 0 [Note] InnoDB: Number of pools: 1

2025-01-22 15:02:58 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-01-22 15:02:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-01-22 15:02:58 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-22 15:02:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2025-01-22 15:02:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2025-01-22 15:02:59 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2025-01-22 15:02:59 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2025-01-22 15:02:59 0 [Note] InnoDB: Waiting for purge to start

2025-01-22 15:02:59 0 [Note] InnoDB: 10.4.32 started; log sequence number 300351; transaction id 170

2025-01-22 15:02:59 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-01-22 15:02:59 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2025-01-22 15:02:59 0 [Note] Server socket created on IP: '::'.

2025-01-22 15:02:59 0 [Note] InnoDB: Buffer pool(s) load completed at 250122 15:02:59

2025-01-22 15:02:59 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.

2025-01-22 15:02:59 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2025-01-22 15:02:59 0 [ERROR] Aborting

2025-01-22 15:06:56 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 23412

2025-01-22 15:06:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-01-22 15:06:56 0 [Note] InnoDB: Uses event mutexes

2025-01-22 15:06:56 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-01-22 15:06:56 0 [Note] InnoDB: Number of pools: 1

2025-01-22 15:06:56 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-01-22 15:06:56 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-01-22 15:06:56 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-22 15:06:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2025-01-22 15:06:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2025-01-22 15:06:56 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2025-01-22 15:06:56 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2025-01-22 15:06:56 0 [Note] InnoDB: Waiting for purge to start

2025-01-22 15:06:56 0 [Note] InnoDB: 10.4.32 started; log sequence number 300360; transaction id 170

2025-01-22 15:06:56 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2025-01-22 15:06:56 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-01-22 15:06:56 0 [Note] InnoDB: Buffer pool(s) load completed at 250122 15:06:56

2025-01-22 15:06:56 0 [Note] Server socket created on IP: '::'.

2025-01-22 15:06:56 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.

2025-01-22 15:06:56 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2025-01-22 15:06:56 0 [ERROR] Aborting

2025-01-22 15:06:59 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 12956

2025-01-22 15:06:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-01-22 15:06:59 0 [Note] InnoDB: Uses event mutexes

2025-01-22 15:06:59 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-01-22 15:06:59 0 [Note] InnoDB: Number of pools: 1

2025-01-22 15:06:59 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-01-22 15:06:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-01-22 15:06:59 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-22 15:06:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2025-01-22 15:06:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2025-01-22 15:06:59 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2025-01-22 15:06:59 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2025-01-22 15:06:59 0 [Note] InnoDB: Waiting for purge to start

2025-01-22 15:06:59 0 [Note] InnoDB: 10.4.32 started; log sequence number 300369; transaction id 170

2025-01-22 15:06:59 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2025-01-22 15:06:59 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-01-22 15:06:59 0 [Note] InnoDB: Buffer pool(s) load completed at 250122 15:06:59

2025-01-22 15:06:59 0 [Note] Server socket created on IP: '::'.

2025-01-22 15:06:59 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.

2025-01-22 15:06:59 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2025-01-22 15:06:59 0 [ERROR] Aborting

2025-01-22 15:13:02 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 4464

2025-01-22 15:13:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-01-22 15:13:02 0 [Note] InnoDB: Uses event mutexes

2025-01-22 15:13:02 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-01-22 15:13:02 0 [Note] InnoDB: Number of pools: 1

2025-01-22 15:13:02 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-01-22 15:13:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-01-22 15:13:02 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-22 15:13:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2025-01-22 15:13:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2025-01-22 15:13:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2025-01-22 15:13:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2025-01-22 15:13:02 0 [Note] InnoDB: Waiting for purge to start

2025-01-22 15:13:02 0 [Note] InnoDB: 10.4.32 started; log sequence number 300378; transaction id 170

2025-01-22 15:13:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2025-01-22 15:13:02 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-01-22 15:13:02 0 [Note] InnoDB: Buffer pool(s) load completed at 250122 15:13:02

2025-01-22 15:13:02 0 [Note] Server socket created on IP: '::'.

2025-01-22 15:13:02 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.

2025-01-22 15:13:02 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2025-01-22 15:13:02 0 [ERROR] Aborting

Answer 1

你好，

感谢您在微软社区论坛上的发帖。

从您提供的信息上来看3306端口可能被其他服务占用，我建议您打开cmd运行以下命令查看占用该端口的PID：

netstat -aon|findstr "3306"

您也可以使用以下命令终止对应PID 进程。

taskkill /f /pid 666

但是，如果想要找出服务占用端口的具体原因，还是需要找到 pid 对应的服务。我建议您打开任务管理器进行查找。

此致

Zunhui