mysql after 报错_xammp本地 mysql报错，无法启动mysql解决办法。

出错的内容：

备注：这里大概意思是意外关闭数据库造成的错误，让我检查日志文件和端口

日志文件报错：

InnoDB: using atomic writes.

2020-08-13 20:31:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2020-08-13 20:31:52 0 [Note] InnoDB: Uses event mutexes

2020-08-13 20:31:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-08-13 20:31:52 0 [Note] InnoDB: Number of pools: 1

2020-08-13 20:31:52 0 [Note] InnoDB: Using SSE2 crc32 instructions

2020-08-13 20:31:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2020-08-13 20:31:52 0 [Note] InnoDB: Completed initialization of buffer pool

2020-08-13 20:31:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2020-08-13 20:31:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2020-08-13 20:31:52 0 [Note] InnoDB: Setting file 'E:\xammp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2020-08-13 20:31:52 0 [Note] InnoDB: File 'E:\xammp\mysql\data\ibtmp1' size is now 12 MB.

2020-08-13 20:31:52 0 [Note] InnoDB: Waiting for purge to start

2020-08-13 20:31:52 0 [Note] InnoDB: 10.4.11 started; log sequence number 447771; transaction id 807

2020-08-13 20:31:52 0 [Note] InnoDB: Loading buffer pool(s) from E:\xammp\mysql\data\ib_buffer_pool

2020-08-13 20:31:52 0 [Note] Plugin 'FEEDBACK' is disabled.

2020-08-13 20:31:52 0 [Note] Server socket created on IP: '::'.

解决办法：

方法一：

改端口。打开Mysql的my.ini文件，将端口3306改成3307或者3316都可

改完后保存重新启动

方法二：

方法三：

在mysql/bin/my.ini 文件下的[mysqld]加一个：innodb_force_recovery = 4

保存重启

方法四：

将图中的带@的文件删除，请注意看时间，和你出错的时间相仿的。

重启

以上就是关于这个问题的解决办法，如果还是不能解决，请百度。