美文网首页
Variable ‘time_zone’ can’t be se

Variable ‘time_zone’ can’t be se

作者: 雨哥 | 来源:发表于2020-12-11 10:53 被阅读0次

    MYSQL恢复数据库时出现如下错误:
    ERROR 1231 (42000): Variable ‘time_zone’ can’t be set to the value of ‘NULL’
    ERROR 1231 (42000): Variable ‘sql_mode’ can’t be set to the value of ‘NULL’
    ERROR 1231 (42000): Variable ‘foreign_key_checks’ can’t be set to the value of ‘NULL’
    ERROR 1231 (42000): Variable ‘unique_checks’ can’t be set to the value of ‘NULL’
    ERROR 1231 (42000): Variable ‘character_set_client’ can’t be set to the value of ‘NULL’
    Query OK, 0 rows affected (0.00 sec)
    解决方案

    mysql> set global max_allowed_packet=1000000000;
    

    相关文章

      网友评论

          本文标题:Variable ‘time_zone’ can’t be se

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