エラー1231(42000)を解決します:変数 'time_zone'はできません
Solve Error 1231
データの移行または復元中に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を再起動します。
|_+_|
転載:https://blog.51cto.com/9285090/2119091