• ADADADADAD

    [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.[ mysql数据库 ]

    mysql数据库 时间:2024-12-24 19:13:17

    作者:文/会员上传

    简介:

    2017-07-28T12:46:35.138596Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    2017-07-28T12:46:35.138596Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


    其实这个报错在安装的初始化的时候就已经有了(在第一篇安装的文章中能看到),只不过没有影响安装和启动,所以并没有管,以为只是安装的时候检查类的报错,后来在重启mysql发现在error日志里面也会出现这个报错


    解决方法:

    在mysql官方网站上找到这么一段话

    Those nonstandard behaviors remain the default for TIMESTAMP but as of MySQL 5.6.6 are deprecated and this warning appears at startup:


    [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.

    Please use --explicit_defaults_for_timestamp server option (see

    documentation for more details).

    As indicated by the warning, to turn off the nonstandard behaviors,

    enable the new explicit_defaults_for_timestamp system variable at server startup.

    With this variable enabled, the server handles TIMESTAMP as follows instead:


    这段话的意思是在5.6以后有这么一项检查,所以要开启标准的 explicit_defaults_for_timestamp功能,但是默认是关闭的。


    在my.cnf中加入

    [mysqld]

    explicit_defaults_for_timestamp=true


    如果还是报错,按mysql提示的执行下面的mysql启动命令:

    ./bin/mysqld_safe --user=mysql --explicit_defaults_for_timestamp=1 &


    [Warning] TIMESTAMP with implicit DEFAULT value is deprecated..docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: timestampwithimplicit