エラー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_pa​​cket = 1024M



mysqlを再起動します。

|_+_|


転載:https://blog.51cto.com/9285090/2119091