首页 > 学院 > 综合知识 > 正文

解决ERROR 1231 42000 Variable time_zone can t

2022-07-12 11:39:40
字体:
来源:转载
供稿:网友
  解决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)
  ERROR 1231 (42000): Variable 'collation_connection' can't be set to the value of 'NULL'
  ERROR 1231 (42000): Variable 'sql_notes' can't be set to the value of 'NULL'
  解决办法:
 
  修改mysql配置文件:max_allowed_packet=1024M
 
  重启mysql:
 
  # systemctl  restart mysql.service

(编辑:错新网)

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表