首页 » Linux » mysql 5.7安装之后,启动报错

mysql 5.7安装之后,启动报错

 

mysql 5.7启动的时候报错:

2018-05-31T08:54:35.293190Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: ./ibdata1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2018-05-31T08:54:35.293252Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2018-05-31T08:54:35.293270Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2018-05-31T08:54:35.893752Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-05-31T08:54:35.893789Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-05-31T08:54:35.893796Z 0 [ERROR] Failed to initialize builtin plugins.
2018-05-31T08:54:35.893800Z 0 [ERROR] Aborting

配置文件是复制过来的,在别的机器 上是可以用的,所以配置文件是没有问题,

后面把配置文件一段一段的测试,发现开启了binlog就会报错,所以是binlog的问题,发现binlog应该是与server-id有关,发现配置文件中没有配置,所以加上server-id的配置就可以了。

原文链接:mysql 5.7安装之后,启动报错,转载请注明来源!

6