XAMPP MYSQL Not Starting on windows

[bryanm]

Hi, my XAMPP control panel is not starting MYSQL. It was working perfectly fine for weeks, and I was working on a project with MYSQL running. Suddenly, it just stopped working and won't start. The log can be found using the link. https://pastebin.com/KUU4Wcw3

[Altrea]

Hi,

your logs don't contain any helpful information about your issue.

Please try to start MariaDB as console application and tell us what log messages you get there:

• start the XAMPP shell by clicking the [Shell] button in your XAMPP control panel
• execute the following command
  

  Code: Select all

  mysqld --defaults-file=mysql\bin\my.ini --standalone --console

[muneerwebdev]

hello, i also had the same issue and i executed the shell command. please see below :

Code: Select all

# mysqld --defaults-file=mysql\bin\my.ini --standalone --console

2023-08-20 22:19:06 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2023-08-20 22:19:06 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 3296
2023-08-20 22:19:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-08-20 22:19:06 0 [Note] InnoDB: Uses event mutexes
2023-08-20 22:19:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-08-20 22:19:06 0 [Note] InnoDB: Number of pools: 1
2023-08-20 22:19:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-08-20 22:19:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-08-20 22:19:06 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-20 22:19:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-08-20 22:19:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-08-20 22:19:06 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-08-20 22:19:06 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-08-20 22:19:06 0 [Note] InnoDB: Waiting for purge to start
2023-08-20 22:19:07 0 [Note] InnoDB: 10.4.28 started; log sequence number 888732791; transaction id 55561
2023-08-20 22:19:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-08-20 22:19:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-20 22:19:07 0 [Note] Server socket created on IP: '::'.
2023-08-20 22:19:07 0 [ERROR] mysqld: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2023-08-20 22:19:07 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2023-08-20 22:19:07 0 [ERROR] Aborting