12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间：2024-12-24 19:13:14
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
解决mysql 数据库在迁移或还原数据过程中出现的如下报错：ERROR1231(42000):Variable'time_zone'can'tbesettothevalueof'NULL'ERROR1231(42000):Variabl
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
解决mysql 数据库在迁移或还原数据过程中出现的如下报错：
ERROR1231(42000):Variable'time_zone'can'tbesettothevalueof'NULL'ERROR1231(42000):Variable'sql_mode'can'tbesettothevalueof'NULL'ERROR1231(42000):Variable'foreign_key_checks'can'tbesettothevalueof'NULL'ERROR1231(42000):Variable'unique_checks'can'tbesettothevalueof'NULL'ERROR1231(42000):Variable'character_set_client'can'tbesettothevalueof'NULL'QueryOK,0rowsaffected(0.00sec)ERROR1231(42000):Variable'collation_connection'can'tbesettothevalueof'NULL'ERROR1231(42000):Variable'sql_notes'can'tbesettothevalueof'NULL'
解决办法：
修改mysql配置文件:max_allowed_packet=1024M
重启mysql：
#systemctlrestartmysql.service
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19