mysql无法启动成功,1067错误

    xiaoxiao2021-03-25  83

    mysql无法启动成功 场景:系统服务器关机后,重启后无法启动。 事件服务的日志如下: InnoDB: Attempted to open a previously opened tablespace. Previous tablespace jeeplus_schema_v1/accident_detail uses space ID: 1 at filepath: .\jeeplus_schema_v1\accident_detail.ibd. Cannot open tablespace mysql/innodb_table_stats which uses space ID: 1 at filepath: .\mysql\innodb_table_stats.ibd 解决方法: (转)http://www.cnblogs.com/wtfbk/p/5228924.html

    编辑/etc/my.cnf,添加

    [mysqld] innodb_force_recovery=1

    重启数据库服务

    启动成功后,在去掉该条记录,再次重启数据库服务,即可。

    可参看:http://www.softaculous.com/board/index.php?tid=4700&title=MySQL_not_starting

    转载请注明原文地址: https://ju.6miu.com/read-36640.html

    最新回复(0)