mysql - Mysql 在我启动时从 Xampp 关闭
问题描述
它开始了今天的一切,当时我打算将权限从 root 授予 MySql(MariaDB)的另一个用户。然后我得到“错误1034(HY000):表'db'的索引已损坏;尝试修复它”,我尝试了命令repair table mysql.db并且与本地主机的连接失败。然后Mysql第一次崩溃了。我多次尝试重新启动它,但它不断关闭。我还尝试重新启动计算机以检查是否某些端口被占用,但情况仍然存在。我能做些什么?先感谢您
编辑:
错误日志:
InnoDB: using atomic writes.
2019-11-24 13:23:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-24 13:23:05 0 [Note] InnoDB: Uses event mutexes
2019-11-24 13:23:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-24 13:23:05 0 [Note] InnoDB: Number of pools: 1
2019-11-24 13:23:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-24 13:23:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-24 13:23:05 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-24 13:23:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-24 13:23:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-24 13:23:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-24 13:23:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-24 13:23:05 0 [Note] InnoDB: Waiting for purge to start
2019-11-24 13:23:05 0 [Note] InnoDB: 10.4.8 started; log sequence number 1853753; transaction id 2559
2019-11-24 13:23:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-24 13:23:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-24 13:23:05 0 [Note] Server socket created on IP: '::'.
解决方案
推荐阅读
- c - stat() 提供错误信息
- java - coursera java课程中方法中的getAverageRank问题
- python - 用 Python 重命名一个带有文件名的目录
- database - SQLite - 如何获取字符串中所有字符的出现
- javascript - VUEX,$store.state 为空时怎么办
- angular8 - 同步融合中连接器的重叠
- mysql - 如何在 SQL 中多次关联表?
- python - Sympy solveset 将结果存储为浮点数、整数等
- excel - VBA 中的行数和列数显示不正确
- amazon-web-services - AWS Api Gateway 与 S3 作为 AWS 服务集成的 SAM 模板