mysql stops after starting

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

mysql stops after starting

Postby nikhil2004 » 11. January 2024 05:38

[color=#0040FF]2023-01-23 13:00:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-01-23 13:00:22 0 [Note] InnoDB: Uses event mutexes
2023-01-23 13:00:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-01-23 13:00:22 0 [Note] InnoDB: Number of pools: 1
2023-01-23 13:00:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-01-23 13:00:23 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-01-23 13:00:23 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-23 13:00:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2023-01-23 13:00:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-01-23 13:00:25 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-01-23 13:00:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-23 13:00:25 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-23 13:00:25 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-01-23 13:00:25 0 [Note] InnoDB: Waiting for purge to start
2023-01-23 13:00:25 0 [Note] InnoDB: 10.4.27 started; log sequence number 300297; transaction id 170
2023-01-23 13:00:25 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-01-23 13:00:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-23 13:00:25 0 [Note] Server socket created on IP: '::'.
2023-01-24 14:42:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-01-24 14:42:49 0 [Note] InnoDB: Uses event mutexes
2023-01-24 14:42:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-01-24 14:42:49 0 [Note] InnoDB: Number of pools: 1
2023-01-24 14:42:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-01-24 14:42:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-01-24 14:42:50 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-24 14:42:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=311042
2023-01-24 14:42:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-01-24 14:42:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-01-24 14:42:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-24 14:42:51 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-24 14:42:51 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-01-24 14:42:51 0 [Note] InnoDB: Waiting for purge to start
2023-01-24 14:42:51 0 [Note] InnoDB: 10.4.27 started; log sequence number 311051; transaction id 218
2023-01-24 14:42:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-01-24 14:42:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-24 14:42:52 0 [Note] InnoDB: Buffer pool(s) load completed at 230124 14:42:52
2023-01-24 14:42:52 0 [Note] Server socket created on IP: '::'.
2023-01-24 22:31:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-01-24 22:31:27 0 [Note] InnoDB: Uses event mutexes
2023-01-24 22:31:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-01-24 22:31:27 0 [Note] InnoDB: Number of pools: 1
2023-01-24 22:31:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-01-24 22:31:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-01-24 22:31:27 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-24 22:31:27 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=331083
2023-01-24 22:31:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-01-24 22:31:28 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-01-24 22:31:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-24 22:31:28 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-24 22:31:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-01-24 22:31:28 0 [Note] InnoDB: 10.4.27 started; log sequence number 331092; transaction id 311
2023-01-24 22:31:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-01-24 22:31:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-24 22:31:28 0 [Note] Server socket created on IP: '::'.
2024-01-11 9:36:14 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-11 9:36:14 0 [Note] InnoDB: Uses event mutexes
2024-01-11 9:36:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2024-01-11 9:36:14 0 [Note] InnoDB: Number of pools: 1
2024-01-11 9:36:14 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-11 9:36:14 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-11 9:36:14 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-11 9:36:14 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=370735
2024-01-11 9:36:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-11 9:36:14 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-01-11 9:36:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-11 9:36:14 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-11 9:36:14 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-11 9:36:14 0 [Note] InnoDB: Waiting for purge to start
2024-01-11 9:36:14 0 [Note] InnoDB: 10.4.27 started; log sequence number 370744; transaction id 449
2024-01-11 9:36:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-11 9:36:14 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-11 9:36:15 0 [Note] Server socket created on IP: '::'.
2024-01-11 9:36:15 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.


2024-01-11 9:36:15 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-01-11 9:36:15 0 [ERROR] Aborting
2024-01-11 9:36:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-11 9:36:47 0 [Note] InnoDB: Uses event mutexes
2024-01-11 9:36:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2024-01-11 9:36:47 0 [Note] InnoDB: Number of pools: 1
2024-01-11 9:36:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-11 9:36:47 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-11 9:36:47 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-11 9:36:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-11 9:36:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-11 9:36:47 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-11 9:36:47 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-11 9:36:47 0 [Note] InnoDB: Waiting for purge to start
2024-01-11 9:36:48 0 [Note] InnoDB: 10.4.27 started; log sequence number 370753; transaction id 449
2024-01-11 9:36:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-11 9:36:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-11 9:36:48 0 [Note] Server socket created on IP: '::'.
2024-01-11 9:36:48 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.


2024-01-11 9:36:48 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-01-11 9:36:48 0 [ERROR] Aborting
2024-01-11 9:38:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-11 9:38:20 0 [Note] InnoDB: Uses event mutexes
2024-01-11 9:38:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2024-01-11 9:38:20 0 [Note] InnoDB: Number of pools: 1
2024-01-11 9:38:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-11 9:38:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-11 9:38:20 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-11 9:38:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-11 9:38:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-11 9:38:21 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-11 9:38:21 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-11 9:38:21 0 [Note] InnoDB: 10.4.27 started; log sequence number 370762; transaction id 449
2024-01-11 9:38:21 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-11 9:38:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-11 9:38:21 0 [Note] Server socket created on IP: '::'.
2024-01-11 9:38:21 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.


2024-01-11 9:38:21 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-01-11 9:38:21 0 [ERROR] Aborting
2024-01-11 9:42:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-11 9:42:57 0 [Note] InnoDB: Uses event mutexes
2024-01-11 9:42:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2024-01-11 9:42:57 0 [Note] InnoDB: Number of pools: 1
2024-01-11 9:42:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-11 9:42:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-11 9:42:57 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-11 9:42:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-11 9:42:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-11 9:42:58 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-11 9:42:58 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-11 9:42:58 0 [Note] InnoDB: Waiting for purge to start
2024-01-11 9:42:58 0 [Note] InnoDB: 10.4.27 started; log sequence number 370771; transaction id 449
2024-01-11 9:42:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-11 9:42:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-11 9:42:58 0 [Note] Server socket created on IP: '::'.
2024-01-11 9:42:58 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.


2024-01-11 9:42:58 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-01-11 9:42:58 0 [ERROR] Aborting
2024-01-11 9:44:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-11 9:44:09 0 [Note] InnoDB: Uses event mutexes
2024-01-11 9:44:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2024-01-11 9:44:09 0 [Note] InnoDB: Number of pools: 1
2024-01-11 9:44:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-11 9:44:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-11 9:44:09 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-11 9:44:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-11 9:44:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-11 9:44:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-11 9:44:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-11 9:44:10 0 [Note] InnoDB: Waiting for purge to start
2024-01-11 9:44:10 0 [Note] InnoDB: 10.4.27 started; log sequence number 370780; transaction id 449
2024-01-11 9:44:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-11 9:44:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-11 9:44:10 0 [Note] Server socket created on IP: '::'.
2024-01-11 9:44:10 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.


2024-01-11 9:44:10 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-01-11 9:44:10 0 [ERROR] Aborting
2024-01-11 10:04:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-11 10:04:54 0 [Note] InnoDB: Uses event mutexes
2024-01-11 10:04:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2024-01-11 10:04:54 0 [Note] InnoDB: Number of pools: 1
2024-01-11 10:04:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-11 10:04:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-11 10:04:54 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-11 10:04:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-11 10:04:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-11 10:04:54 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-11 10:04:54 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-11 10:04:54 0 [Note] InnoDB: Waiting for purge to start
2024-01-11 10:04:54 0 [Note] InnoDB: 10.4.27 started; log sequence number 370789; transaction id 449
2024-01-11 10:04:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-11 10:04:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-11 10:04:54 0 [Note] InnoDB: Buffer pool(s) load completed at 240111 10:04:54
2024-01-11 10:04:54 0 [Note] Server socket created on IP: '::'.
2024-01-11 10:04:54 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.


2024-01-11 10:04:54 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
nikhil2004
 
Posts: 2
Joined: 11. January 2024 05:32
XAMPP version: 3.3.0
Operating System: windows 11

Re: mysql stops after starting

Postby nikhil2004 » 11. January 2024 06:05

go to task manager....in processes search for mysqld or mysqld.exe.....right click and end the task
nikhil2004
 
Posts: 2
Joined: 11. January 2024 05:32
XAMPP version: 3.3.0
Operating System: windows 11


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 167 guests