首页 > 解决方案 > 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: '::'.

标签: mysqldatabasexamppmariadb

解决方案


推荐阅读