This is the error that I am getting
InnoDB: using atomic writes.
2021-11-03 14:44:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-03 14:44:17 0 [Note] InnoDB: Uses event mutexes
2021-11-03 14:44:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-03 14:44:17 0 [Note] InnoDB: Number of pools: 1
2021-11-03 14:44:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-03 14:44:17 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-03 14:44:17 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-03 14:44:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-03 14:44:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-03 14:44:18 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-03 14:44:18 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-03 14:44:18 0 [Note] InnoDB: 10.4.11 started; log sequence number 177899181; transaction id 258473
2021-11-03 14:44:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-03 14:44:18 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-03 14:44:18 0 [Note] Server socket created on IP: '::'.
2021-11-03 14:44:18 0 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'db'
2021-11-03 14:44:18 0 [ERROR] Aborting
2021-11-03 14:44:18 0 [ERROR] InnoDB: Expected tablespace id 2 but found 4294967294 in the file .\mysql\innodb_index_stats.ibd
2021-11-03 14:44:18 0 [ERROR] InnoDB: Expected tablespace id 2 but found 4294967294 in the file .\mysql\innodb_index_stats.ibd
I am seeing online that there is a way to fix this but I am not understanding how to do it. I saw this MySQL Fatal error: Can't open and lock privilege tables: Incorrect file format 'user' But I don't know what terminal I am trying to run the sudo mysqld command from the 1st comment but I am not getting anything, it's saying that sudo command doesn't exist. Am I supposed to do this in a specific folder? I am trying to run this code in visual studio code terminal, am I using the wrong thing to try to do this?
I am on Windows 11 and I am using xampp version v3.2.4. I checked to make sure no other MySQL services are running.
I'd appreciate the help, thanks!!!
I would uninstall and then reinstall xampp but I have some data that I need to get access to on my PHPMyAdmin before I do that.
