2022-04-19 17:48:20 0 [Note] InnoDB: Uses event mutexes
2022-04-19 17:48:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-19 17:48:20 0 [Note] InnoDB: Number of pools: 1
2022-04-19 17:48:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-04-19 17:48:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-04-19 17:48:20 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-19 17:48:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-04-19 17:48:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-19 17:48:20 0 [Note] InnoDB:
2022-04-19 17:48:20 0 [Note] InnoDB: File 'C:\Programs\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-04-19 17:48:20 0 [Note] InnoDB: Waiting for purge to start
2022-04-19 17:48:20 0 [Note] InnoDB: 10.4.22 started; log sequence number 64561191; transaction id 22574
2022-04-19 17:48:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\Programs\xampp\mysql\data\ib_buffer_pool
2022-04-19 17:48:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-19 17:48:20 0 [Note] Server socket created on IP: '::'.
解决方案
This one helped for me:
Open shell from from control panel and start mysql with this command:
mysqld –-console –-skip-grant-tables –-skip-external-locking
Open another shell from control panel and repair database with this command:
mysqlcheck -r --databases mysql --use-frm
Stop mysql, close shells and restart mysql normally.