Unable to start 'MySQL' via the XAMPP Control Panel

[Dave182]

Hi, I am unable to start MySQL via the XAMPP Control Panel.



error log bellow:

What else do you need to know?

I did install a free trial 14 day version of Navitcat for MySQL

I also had to disable UAC for windows but have since tried it whilst enabled and not

I also have disable antivirus as well.

I also got the to point of allowing firewall pop up.
____________________________________

2022-01-03 13:02:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-03 13:02:53 0 [Note] InnoDB: Uses event mutexes
2022-01-03 13:02:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-03 13:02:53 0 [Note] InnoDB: Number of pools: 1
2022-01-03 13:02:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-03 13:02:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-03 13:02:53 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-03 13:02:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2022-01-03 13:02:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-03 13:02:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-01-03 13:02:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-03 13:02:53 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-03 13:02:53 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-01-03 13:02:53 0 [Note] InnoDB: Waiting for purge to start
2022-01-03 13:02:54 0 [Note] InnoDB: 10.4.22 started; log sequence number 300297; transaction id 170
2022-01-03 13:02:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-01-03 13:02:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-03 13:02:54 0 [Note] Server socket created on IP: '::'.
2022-01-03 13:03:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-03 13:03:03 0 [Note] InnoDB: Uses event mutexes
2022-01-03 13:03:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-03 13:03:03 0 [Note] InnoDB: Number of pools: 1
2022-01-03 13:03:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-03 13:03:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-03 13:03:03 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-03 13:03:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-03 13:03:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-03 13:03:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-03 13:03:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-01-03 13:03:03 0 [Note] InnoDB: Waiting for purge to start
2022-01-03 13:03:03 0 [Note] InnoDB: 10.4.22 started; log sequence number 300306; transaction id 170
2022-01-03 13:03:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-01-03 13:03:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-03 13:03:03 0 [Note] Server socket created on IP: '::'.
2022-01-03 13:03:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-03 13:03:33 0 [Note] InnoDB: Uses event mutexes
2022-01-03 13:03:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-03 13:03:33 0 [Note] InnoDB: Number of pools: 1
2022-01-03 13:03:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-03 13:03:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-03 13:03:33 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-03 13:03:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-03 13:03:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-03 13:03:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-03 13:03:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-01-03 13:03:33 0 [Note] InnoDB: Waiting for purge to start
2022-01-03 13:03:33 0 [Note] InnoDB: 10.4.22 started; log sequence number 300315; transaction id 170
2022-01-03 13:03:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-01-03 13:03:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-03 13:03:33 0 [Note] Server socket created on IP: '::'.
2022-01-03 13:03:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-03 13:03:39 0 [Note] InnoDB: Uses event mutexes
2022-01-03 13:03:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-03 13:03:39 0 [Note] InnoDB: Number of pools: 1
2022-01-03 13:03:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-03 13:03:39 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-03 13:03:39 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-03 13:03:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-03 13:03:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-03 13:03:39 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-03 13:03:39 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-01-03 13:03:39 0 [Note] InnoDB: Waiting for purge to start
2022-01-03 13:03:39 0 [Note] InnoDB: 10.4.22 started; log sequence number 300324; transaction id 170
2022-01-03 13:03:39 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-01-03 13:03:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-03 13:03:39 0 [Note] Server socket created on IP: '::'.
2022-01-03 13:04:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-03 13:04:43 0 [Note] InnoDB: Uses event mutexes
2022-01-03 13:04:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-03 13:04:43 0 [Note] InnoDB: Number of pools: 1
2022-01-03 13:04:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-03 13:04:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-03 13:04:43 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-03 13:04:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-03 13:04:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-03 13:04:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-03 13:04:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-01-03 13:04:44 0 [Note] InnoDB: Waiting for purge to start
2022-01-03 13:04:44 0 [Note] InnoDB: 10.4.22 started; log sequence number 300333; transaction id 170
2022-01-03 13:04:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-01-03 13:04:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-03 13:04:44 0 [Note] Server socket created on IP: '::'.
2022-01-03 13:04:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-03 13:04:57 0 [Note] InnoDB: Uses event mutexes
2022-01-03 13:04:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-03 13:04:57 0 [Note] InnoDB: Number of pools: 1
2022-01-03 13:04:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-03 13:04:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-03 13:04:57 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-03 13:04:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-03 13:04:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-03 13:04:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-03 13:04:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-01-03 13:04:57 0 [Note] InnoDB: Waiting for purge to start
2022-01-03 13:04:57 0 [Note] InnoDB: 10.4.22 started; log sequence number 300342; transaction id 170
2022-01-03 13:04:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-01-03 13:04:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-03 13:04:57 0 [Note] Server socket created on IP: '::'.
2022-01-03 13:07:08 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-03 13:07:08 0 [Note] InnoDB: Uses event mutexes
2022-01-03 13:07:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-03 13:07:08 0 [Note] InnoDB: Number of pools: 1
2022-01-03 13:07:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-03 13:07:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-03 13:07:08 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-03 13:07:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-03 13:07:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-03 13:07:08 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-03 13:07:08 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-01-03 13:07:08 0 [Note] InnoDB: Waiting for purge to start
2022-01-03 13:07:09 0 [Note] InnoDB: 10.4.22 started; log sequence number 300351; transaction id 170
2022-01-03 13:07:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-01-03 13:07:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-03 13:07:09 0 [Note] Server socket created on IP: '::'.
2022-01-03 13:09:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-03 13:09:35 0 [Note] InnoDB: Uses event mutexes
2022-01-03 13:09:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-03 13:09:35 0 [Note] InnoDB: Number of pools: 1
2022-01-03 13:09:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-03 13:09:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-03 13:09:35 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-03 13:09:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-03 13:09:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-03 13:09:35 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-03 13:09:35 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-01-03 13:09:35 0 [Note] InnoDB: Waiting for purge to start
2022-01-03 13:09:35 0 [Note] InnoDB: 10.4.22 started; log sequence number 300360; transaction id 170
2022-01-03 13:09:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-01-03 13:09:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-03 13:09:35 0 [Note] Server socket created on IP: '::'.
2022-01-03 13:14:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-03 13:14:58 0 [Note] InnoDB: Uses event mutexes
2022-01-03 13:14:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-03 13:14:58 0 [Note] InnoDB: Number of pools: 1
2022-01-03 13:14:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-03 13:14:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-03 13:14:58 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-03 13:14:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-03 13:14:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-03 13:14:58 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-03 13:14:58 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-01-03 13:14:58 0 [Note] InnoDB: Waiting for purge to start
2022-01-03 13:14:58 0 [Note] InnoDB: 10.4.22 started; log sequence number 300369; transaction id 170
2022-01-03 13:14:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-01-03 13:14:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-03 13:14:58 0 [Note] Server socket created on IP: '::'.

[Altrea]

Hi,

Your Log does not contain any errors. It says MariaDB could be started successfully.
So maybe the control panel cannot check properly if the port is being captured by the XAMPP MariaDB.

Please start your control panel with enhanced Administrator rights (rightclick xampp.control.exe -> run as Administrator)

[Dave182]

I followed the fix in the linked image to fix the issue.



TY

It works for me where no error then comes up in the XAMPP Control Panel after applying that fix.

I'll try this as well since I have to run those commands each time at the moment.

Thanks for your reply.

[Dave182]

The control panel still reds out even after I run the exe of XAMPP in Admin Mode ... I just use the other fix you came up with in that other thread I screen shotted.

[Altrea]

Don't try random fixes, analyze the issue.
In nearly all of my replied topics about MariaDB issues you will find the command to start MariaDB as console application.
This will produce messages that can identify commonly.