mysql - 本地主机上的 MySQL 未在 Web 上加载(xampp)
问题描述
我使用 XAMPP,我尝试继续 http://localhost/phpmyadmin 并且页面没有加载..
我打开 mysql_error.log 我有这个:
有人能帮我吗?
2021-02-14 14:17:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-02-14 14:17:04 0 [Note] InnoDB: Uses event mutexes
2021-02-14 14:17:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-14 14:17:04 0 [Note] InnoDB: Number of pools: 1
2021-02-14 14:17:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-14 14:17:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-02-14 14:17:04 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-14 14:17:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131862302
2021-02-14 14:17:04 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=105, page number=13030] with future log sequence number 1467194866
2021-02-14 14:17:04 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=105, page number=13029] with future log sequence number 1467196090
2021-02-14 14:17:04 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=406, page number=315] with future log sequence number 2887772236
2021-02-14 14:17:04 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=406, page number=271] with future log sequence number 2888068173
2021-02-14 14:17:04 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=510, page number=3785] with future log sequence number 2928809900
2021-02-14 14:17:05 0 [ERROR] InnoDB: Page [page id: space=0, page number=625] log sequence number 3497741956 is in the future! Current system log sequence number 131862320.
2021-02-14 14:17:05 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2021-02-14 14:17:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-14 14:17:05 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-14 14:17:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-14 14:17:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-14 14:17:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-02-14 14:17:05 0 [Note] InnoDB: Waiting for purge to start
2021-02-14 14:17:05 4 [ERROR] InnoDB: Page [page id: space=640, page number=0] log sequence number 3470597324 is in the future! Current system log sequence number 131862320.
2021-02-14 14:17:05 4 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2021-02-14 14:17:05 4 [ERROR] InnoDB: Page [page id: space=640, page number=1] log sequence number 3470350944 is in the future! Current system log sequence number 131862320.
2021-02-14 14:17:05 4 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2021-02-14 14:17:05 0 [Note] InnoDB: 10.4.14 started; log sequence number 131862311; transaction id 95095
2021-02-14 14:17:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-02-14 14:17:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-14 14:17:05 0 [Note] InnoDB: Buffer pool(s) load completed at 210214 14:17:05
2021-02-14 14:17:05 0 [Note] Server socket created on IP: '::'.
解决方案
推荐阅读
- c# - 如何在不剪切单词的情况下逐字母将单词实例化到网格
- c++ - 在 Eigen 中复制模板化函数参数
- python - 如何使用在同一网络上的 PC 上运行的另一个 Python 脚本在 RPi 上执行一段代码或 Python 脚本?
- javascript - 从 html 文件中的 js 文件更新变量
- c# - 遍历嵌套列表
- c# - 如果不手动运行 commit 命令,则无法查看数据库中的更改
- java - graphQL api 请求突然停止工作
- kubernetes - 如何向 kubelet 添加标志
- javascript - 如何将数据目标用于不同的组件?
- vue.js - 强制使用旧版本的 vuejs devtools 或下载旧版本