解决办法:
修改mysql配置文件:
[mysqld] max_allowed_packet=1024M
即可解决
linux的mysql配置文件在这里:
/etc/mysql/my.cnf
附这个配置不足的时候的各种报错:
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 ' 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 '