解决ERROR 1231 (42000): Variable 'time_zone' can't

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