博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
mysql 启动不了了
阅读量:7112 次
发布时间:2019-06-28

本文共 2249 字,大约阅读时间需要 7 分钟。

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

2017-01-03T08:19:19.969163Z mysqld_safe mysqld from pid file /var/data/my3306/run/mysqld.pid ended2017-01-03T08:19:51.304099Z mysqld_safe Starting mysqld daemon with databases from /var/data/my3306/data2017-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 release2017-01-03T08:19:51.435161Z 0 [Warning] The syntax '--metadata_locks_cache_size' is deprecated and will be removed in a future release2017-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.html2017-01-03T08:19:51.856517Z 0 [ERROR] InnoDB: Log block 190938946 at lsn 97760739840 has valid header, but checksum field contains 3735928559, should be 33563454552017-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 error2017-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.

 

转载于:https://www.cnblogs.com/sunss/p/6245403.html

你可能感兴趣的文章
Oracle基础(五)pl/sql进阶(分页过程)
查看>>
Deep Introduction to Go Interfaces.
查看>>
SVG的内部事件添加
查看>>
python
查看>>
Xcode插件优缺点对比(推荐20款插件)
查看>>
IOS-面试题
查看>>
hdu 2055 An easy problem (java)
查看>>
HTML5本地存储——Web SQL Database
查看>>
[异常解决] JTAG 与STM32的SWD连接接线方式
查看>>
webstorm快捷键 webstorm keymap内置快捷键英文翻译、中英对照说明
查看>>
热修改 MySQL 数据库 pt-online-schema-change 的使用详解
查看>>
Android调试优化篇
查看>>
Linux技巧汇总
查看>>
EF框架step by step(8)—Code First DataAnnotations(2)
查看>>
MySQL 若干操作
查看>>
Apache Rewrite规则详解
查看>>
JSON 之JAVA 解析
查看>>
MVC5网站开发之一 总体概述
查看>>
windows编程之菜单操作
查看>>
关键路径法
查看>>