qq_35280588 2018-01-17 08:46 采纳率: 100%
浏览 7075
已采纳

mysql5.7启动报错,配置文件修改后又恢复为最初的配置,启动报错,

这是error_log中的错误信息,希望各位大神帮忙看一下

2018-01-17T16:31:15.955382+08:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-01-17T16:31:15.956199+08:00 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-log) starting as process 8086 ...
2018-01-17T16:31:15.959194+08:00 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
2018-01-17T16:31:15.959221+08:00 0 [Warning] InnoDB: Using innodb_file_format_max 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
2018-01-17T16:31:15.959236+08:00 0 [Warning] InnoDB: innodb-page-size has been changed from the default value 16384 to 8192.
2018-01-17T16:31:15.959284+08:00 0 [Note] InnoDB: PUNCH HOLE support available
2018-01-17T16:31:15.959292+08:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-17T16:31:15.959297+08:00 0 [Note] InnoDB: Uses event mutexes
2018-01-17T16:31:15.959301+08:00 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-01-17T16:31:15.959306+08:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-01-17T16:31:15.959310+08:00 0 [Note] InnoDB: Using Linux native AIO
2018-01-17T16:31:15.959589+08:00 0 [Note] InnoDB: Number of pools: 1
2018-01-17T16:31:15.959656+08:00 0 [Note] InnoDB: Using CPU crc32 instructions
2018-01-17T16:31:15.960602+08:00 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-01-17T16:31:16.109011+08:00 0 [Note] InnoDB: Completed initialization of buffer pool
2018-01-17T16:31:16.119766+08:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-01-17T16:31:16.129910+08:00 0 [ERROR] InnoDB: Data file './ibdata1' uses page size 16384, but the innodb_page_size start-up parameter is 8192
2018-01-17T16:31:16.129942+08:00 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2018-01-17T16:31:16.129954+08:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-01-17T16:31:16.730466+08:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-01-17T16:31:16.730503+08:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-01-17T16:31:16.730518+08:00 0 [ERROR] Failed to initialize plugins.
2018-01-17T16:31:16.730525+08:00 0 [ERROR] Aborting

2018-01-17T16:31:16.730559+08:00 0 [Note] Binlog end
2018-01-17T16:31:16.730649+08:00 0 [Note] Shutting down plugin 'CSV'
2018-01-17T16:31:16.731019+08:00 0 [Note] /usr/sbin/mysqld: Shutdown complete

  • 写回答

6条回答 默认 最新

  • 仲宇 2018-01-17 10:56
    关注

    配置是在my.cnf中配置。
    这个错误,需要在数据库目录下删除ib_logfile0、ib_logfile1、ib_logfile2和ibdata1文件,然后再重启试试。

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(5条)

报告相同问题?

悬赏问题

  • ¥30 Matlab打开默认名称带有/的光谱数据
  • ¥50 easyExcel模板 动态单元格合并列
  • ¥15 res.rows如何取值使用
  • ¥15 在odoo17开发环境中,怎么实现库存管理系统,或独立模块设计与AGV小车对接?开发方面应如何设计和开发?请详细解释MES或WMS在与AGV小车对接时需完成的设计和开发
  • ¥15 CSP算法实现EEG特征提取,哪一步错了?
  • ¥15 游戏盾如何溯源服务器真实ip?需要30个字。后面的字是凑数的
  • ¥15 vue3前端取消收藏的不会引用collectId
  • ¥15 delphi7 HMAC_SHA256方式加密
  • ¥15 关于#qt#的问题:我想实现qcustomplot完成坐标轴
  • ¥15 下列c语言代码为何输出了多余的空格