解决ERROR 1231 42000 Variable time_zone can t

2024-09-12 20:30:15

字体：大中小

来源：转载

供稿：网友

　　解决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

（编辑：武林网）

上一篇：MariaDB10.3 增补AliSQL补丁安全执行Online DDL

下一篇：基于xtrabackup来实现InnoDB存储引擎的备份恢复