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

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条)

报告相同问题?

悬赏问题

  • ¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
  • ¥15 如何在scanpy上做差异基因和通路富集?
  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?