I would like to post a problem with hope to get some kind of support please.
I confess am not a coder and not a professional webmaster, but I was to create a simple Wordpress website, so I dowloaded and installed Xampp 7.3.28-1.
Everything went fine and I started building my site for some hours.
Just one day later, with no apparent reason, MYSQL could not start anymore, even if since the previous day, it was working perfectly.
The log says:
2021-05-26 14:38:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-26 14:38:09 0 [Note] InnoDB: Uses event mutexes
2021-05-26 14:38:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-26 14:38:09 0 [Note] InnoDB: Number of pools: 1
2021-05-26 14:38:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-26 14:38:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-26 14:38:09 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-26 14:38:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-26 14:38:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-26 14:38:09 0 [Note] InnoDB: Setting file 'C:\Users\alccad\XAMP\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-26 14:38:09 0 [Note] InnoDB: File 'C:\Users\alccad\XAMP\mysql\data\ibtmp1' size is now 12 MB.
2021-05-26 14:38:09 0 [Note] InnoDB: Waiting for purge to start
2021-05-26 14:38:09 0 [Note] InnoDB: 10.4.19 started; log sequence number 106591641; transaction id 8588
2021-05-26 14:38:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\Users\alccad\XAMP\mysql\data\ib_buffer_pool
2021-05-26 14:38:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-26 14:38:09 0 [Note] InnoDB: Buffer pool(s) load completed at 210526 14:38:09
2021-05-26 14:38:09 0 [Note] Server socket created on IP: '::'.
If I go inside the Event Viewer, I can find the follwing lines regarding MARIADB:
-Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
-c:\users\alccad\xamp\mysql\bin\mysqld.exe (mysqld 10.4.19-MariaDB) starting as process 18116 ...
-InnoDB: Mutexes and rw_locks use Windows interlocked functions
-InnoDB: Uses event mutexes
-InnoDB: Compressed tables use zlib 1.2.11
-InnoDB: Number of pools: 1
-InnoDB: Using SSE2 crc32 instructions
-InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
-InnoDB: Completed initialization of buffer pool
-InnoDB: 128 out of 128 rollback segments are active.
-InnoDB: Creating shared tablespace for temporary tables
-InnoDB: Setting file 'C:\Users\alccad\XAMP\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
-InnoDB: File 'C:\Users\alccad\XAMP\mysql\data\ibtmp1' size is now 12 MB.
-InnoDB: Waiting for purge to start
-InnoDB: 10.4.19 started; log sequence number 106591641; transaction id 8588
-InnoDB: Loading buffer pool(s) from C:\Users\alccad\XAMP\mysql\data\ib_buffer_pool
-Plugin 'FEEDBACK' is disabled.
-InnoDB: Buffer pool(s) load completed at 210526 14:38:09
-Server socket created on IP: '::'.
And then 3 errors:
-mysqld.exe: Index for table '.\mysql\proxies_priv' is corrupt; try to repair it
-Fatal error: Can't open and lock privilege tables: Index for table '.\mysql\proxies_priv' is corrupt; try to repair it
-Aborting
Something seems to have become corrupted. (My suspect is that something happened when my computer went to suspension while Xampp was running, is it possible?)
But how to fix if MySQL is not running?
Thanks in advance for anyone who can save the day
