【待反馈】mysql启动不了

点击启动会显示启动成功然后还是关闭的状态。

发现外网面板地址进入不了,提示无法访问此网站,重启面板进入后发现数据库停止运行,数据库重启不了

您好，查看mysql的报错日志

1. cat /www/server/data/*.err|grep -i -C 10 error

复制代码

运维风光 发表于 2022-9-28 14:46
您好，查看mysql的报错日志

2022-09-28 13:09:53 11589 [Note] InnoDB: Using CPU crc32 instructions
2022-09-28 13:09:53 11589 [Note] InnoDB: Initializing buffer pool, size = 512.0M
2022-09-28 13:09:53 11589 [Note] InnoDB: Completed initialization of buffer pool
2022-09-28 13:09:53 11589 [Note] InnoDB: Highest supported file format is Barracuda.
2022-09-28 13:09:53 11589 [Note] InnoDB: The log sequence numbers 1626004 and 1626004 in ibdata files do not match the log sequence number 1626124 in the ib_logfiles!
2022-09-28 13:09:53 11589 [Note] InnoDB: Database was not shutdown normally!
2022-09-28 13:09:53 11589 [Note] InnoDB: Starting crash recovery.
2022-09-28 13:09:53 11589 [Note] InnoDB: Reading tablespace information from the .ibd files...
2022-09-28 13:09:54 11589 [Note] InnoDB: Restoring possible half-written data pages
2022-09-28 13:09:54 11589 [Note] InnoDB: from the doublewrite buffer...

秦秦秦 发表于 2022-9-28 15:21
2022-09-28 13:09:53 11589 [Note] InnoDB: Using CPU crc32 instructions
2022-09-28 13:09:53 11589 [N ...

您好，能否执行命令查看错误日志。这些信息都是正常的

运维风光 发表于 2022-9-28 15:52
您好，能否执行命令查看错误日志。这些信息都是正常的

没有其它错误提示,我在配置里添加了innodb_force_recovery=2后启动数据库成功,把该配置改回去后重启数据库一切都正常了

好的，这也是mysql官方推荐的方式。