MYSQL don't start using XAMPP Control Panel v3.2.4 on "Win11 Enterprise"

[Miguel Soares Costa]

Dear fellows.

==> When I try to start MySQL in XAMPP Control Panel V3.2.4, i get the following messages:

08:33:33 [mysql] Attempting to start MySQL app...
08:33:33 [mysql] Status change detected: running
08:33:34 [mysql] Status change detected: stopped
08:33:34 [mysql] Error: MySQL shutdown unexpectedly.
08:33:34 [mysql] This may be due to a blocked port, missing dependencies,
08:33:34 [mysql] improper privileges, a crash, or a shutdown by another method.
08:33:34 [mysql] Press the Logs button to view error logs and check
08:33:34 [mysql] the Windows Event Viewer for more clues
08:33:34 [mysql] If you need more help, copy and post this
08:33:34 [mysql] entire log window on the forums

==> mysql_error,log reports

InnoDB: using atomic writes.
2023-05-15 8:49:23 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-05-15 8:49:23 0 [Note] InnoDB: Uses event mutexes
2023-05-15 8:49:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-05-15 8:49:23 0 [Note] InnoDB: Number of pools: 1
2023-05-15 8:49:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-05-15 8:49:23 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-05-15 8:49:23 0 [Note] InnoDB: Completed initialization of buffer pool
2023-05-15 8:49:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-05-15 8:49:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-05-15 8:49:23 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-05-15 8:49:23 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-05-15 8:49:24 0 [Note] InnoDB: Waiting for purge to start
2023-05-15 8:49:24 0 [Note] InnoDB: 10.4.14 started; log sequence number 2784277; transaction id 695
2023-05-15 8:49:24 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-05-15 8:49:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-05-15 8:49:24 0 [Note] Server socket created on IP: '::'.

==> So, i need your help and expertise urgently. Really urgently!

I hope to hear from you soon.

Thanks in advance.

Best regards.

Miguel

 

[Theveshwar Jayakumar]

Hi  Miguel,

We understand that you're experiencing issues with starting MySQL using XAMPP Control Panel v3.2.4 on "Win11 Enterprise." The error message suggests that MySQL is shutting down unexpectedly, and it could be due to various reasons such as a blocked port, missing dependencies, improper privileges, a crash, or another shutdown method.

To investigate further, you can check the error logs by pressing the "Logs" button in the XAMPP Control Panel. Additionally, you may want to review the Windows Event Viewer for more clues about the issue.

From the provided MySQL error log, it appears that InnoDB, the default storage engine for MySQL, is initializing and loading the buffer pool. However, there doesn't seem to be any error reported in the provided log snippet.

Ensure that the required ports (usually 3306 for MySQL) are not being blocked by any firewall or other applications on your system.

Verify that all the necessary dependencies for XAMPP and MySQL are installed and properly configured.

Check if any other applications or services are using the same port as MySQL. You can try changing the MySQL port to see if it resolves the issue.

Make sure you have the appropriate privileges to run MySQL. Try running XAMPP Control Panel as an administrator.

Thank you for reaching out, and I'll be waiting for your response.

Regards,

Theveshwar