XAMP mysql not opening

Type: Bitnami Support Tool

Description:
XAMP mysql not opening

I have a fresh installation of XAMP on window 7. The MySQL is not starting it shut downs in 5 seconds.
I am hanged here, and nothing is closing even with the task managers.

image

2021-09-10 15:35:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-09-10 15:35:03 0 [Note] InnoDB: Uses event mutexes
2021-09-10 15:35:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-10 15:35:03 0 [Note] InnoDB: Number of pools: 1
2021-09-10 15:35:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-09-10 15:35:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-09-10 15:35:03 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-10 15:35:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2021-09-10 15:35:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-09-10 15:35:05 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2021-09-10 15:35:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-10 15:35:05 0 [Note] InnoDB: Setting file ‘F:\Installations\xampp\mysql\data\ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-09-10 15:35:05 0 [Note] InnoDB: File ‘F:\Installations\xampp\mysql\data\ibtmp1’ size is now 12 MB.
2021-09-10 15:35:05 0 [Note] InnoDB: Waiting for purge to start
2021-09-10 15:35:05 0 [Note] InnoDB: 10.4.21 started; log sequence number 300297; transaction id 170
2021-09-10 15:35:05 0 [Note] InnoDB: Loading buffer pool(s) from F:\Installations\xampp\mysql\data\ib_buffer_pool
2021-09-10 15:35:05 0 [Note] InnoDB: Buffer pool(s) load completed at 210910 15:35:05
2021-09-10 15:35:05 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2021-09-10 15:35:05 0 [Note] Server socket created on IP: ‘::’.
2021-09-10 15:35:05 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.

2021-09-10 15:35:05 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-09-10 15:35:05 0 [ERROR] Aborting
2021-09-10 15:38:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-09-10 15:38:29 0 [Note] InnoDB: Uses event mutexes
2021-09-10 15:38:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-10 15:38:29 0 [Note] InnoDB: Number of pools: 1
2021-09-10 15:38:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-09-10 15:38:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-09-10 15:38:29 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-10 15:38:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-09-10 15:38:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-10 15:38:30 0 [Note] InnoDB: Setting file ‘F:\Installations\xampp\mysql\data\ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-09-10 15:38:30 0 [Note] InnoDB: File ‘F:\Installations\xampp\mysql\data\ibtmp1’ size is now 12 MB.
2021-09-10 15:38:30 0 [Note] InnoDB: Waiting for purge to start
2021-09-10 15:38:30 0 [Note] InnoDB: 10.4.21 started; log sequence number 300306; transaction id 170
2021-09-10 15:38:30 0 [Note] InnoDB: Loading buffer pool(s) from F:\Installations\xampp\mysql\data\ib_buffer_pool
2021-09-10 15:38:30 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2021-09-10 15:38:30 0 [Note] Server socket created on IP: ‘::’.
2021-09-10 15:38:30 0 [Note] InnoDB: Buffer pool(s) load completed at 210910 15:38:30
2021-09-10 15:38:30 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.

2021-09-10 15:38:30 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-09-10 15:38:30 0 [ERROR] Aborting
2021-09-10 19:56:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-09-10 19:56:05 0 [Note] InnoDB: Uses event mutexes
2021-09-10 19:56:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-10 19:56:05 0 [Note] InnoDB: Number of pools: 1
2021-09-10 19:56:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-09-10 19:56:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-09-10 19:56:06 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-10 19:56:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-09-10 19:56:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-10 19:56:07 0 [Note] InnoDB: Setting file ‘F:\Installations\xampp\mysql\data\ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-09-10 19:56:08 0 [Note] InnoDB: File ‘F:\Installations\xampp\mysql\data\ibtmp1’ size is now 12 MB.
2021-09-10 19:56:08 0 [Note] InnoDB: Waiting for purge to start
2021-09-10 19:56:08 0 [Note] InnoDB: Waiting for purge to start
2021-09-10 19:56:08 0 [Note] InnoDB: 10.4.21 started; log sequence number 300315; transaction id 170
2021-09-10 19:56:08 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2021-09-10 19:56:08 0 [Note] InnoDB: Loading buffer pool(s) from F:\Installations\xampp\mysql\data\ib_buffer_pool
2021-09-10 19:56:08 0 [Note] InnoDB: Buffer pool(s) load completed at 210910 19:56:08
2021-09-10 19:56:08 0 [Note] Server socket created on IP: ‘::’.
2021-09-10 19:56:08 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.

2021-09-10 19:56:08 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-09-10 19:56:08 0 [ERROR] Aborting

Hi @codeispoetry,

It seems another instance of MySQL is already running and is blocking port 3306. Can you check in the Task Manager -> Services if this is the case? If so, can you stop the process and try to start XAMPP MySQL then?

Regards,
Michiel

Mysql workbench was installed since 2017, uninstalling it set the XAMPP

1 Like