美文网首页
mysql启动失败(sql-mode)

mysql启动失败(sql-mode)

作者: 月影树下 | 来源:发表于2020-09-11 23:40 被阅读0次

    mysql启动报错:
    Starting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.[FAILED]
    编辑mysql配置文件
    vi /etc/my.conf
    最后一行加sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

    source /etc/my.conf
    再次启动
    service myslqd start

    相关文章

      网友评论

          本文标题:mysql启动失败(sql-mode)

          本文链接:https://www.haomeiwen.com/subject/ftshjktx.html