解决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
解决ERROR 1231 (42000): Variable ‘time_zone‘ can‘t
原文：http://blog.51cto.com/9285090/2119091