mysql 启动不了了

在做测试的工程中,发现mysql启动失败,报错信息如下:

2017-01-03T08:19:19.969163Z mysqld_safe mysqld from pid file /var/data/my3306/run/mysqld.pid ended
2017-01-03T08:19:51.304099Z mysqld_safe Starting mysqld daemon with databases from /var/data/my3306/data
2017-01-03T08:19:51.435091Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2017-01-03T08:19:51.435154Z 0 [Warning] The syntax '--metadata_locks_hash_instances' is deprecated and will be removed in a future release
2017-01-03T08:19:51.435161Z 0 [Warning] The syntax '--metadata_locks_cache_size' is deprecated and will be removed in a future release
2017-01-03T08:19:51.435208Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-03T08:19:51.435232Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2017-01-03T08:19:51.438636Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.
html
2017-01-03T08:19:51.856517Z 0 [ERROR] InnoDB: Log block 190938946 at lsn 97760739840 has valid header, but checksum field contains 3735928559, should be 3356345455
2017-01-03T08:19:51.856549Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 97760740287 and the end 97760739840.
2017-01-03T08:19:51.856565Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-01-03T08:19:52.456983Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-01-03T08:19:52.457013Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-01-03T08:19:52.457021Z 0 [ERROR] Failed to initialize plugins.
2017-01-03T08:19:52.457027Z 0 [ERROR] Aborting

解决办法呢是从网上搜到的“双胞胎拔比”的连接:

也是参考网上的:Solved
http://spin.atomicobject.com/2011/05/09/mysql-failed-registration-of-innodb-as-a-storage-engine/ 

Rename or move both the ./ib_logfile0 and ./ib_logfile1 files, and then start the MySQL server.

 

posted @ 2017-01-03 16:36  sunss  阅读(5395)  评论(0编辑  收藏  举报