Shulou(Shulou.com)06/01 Report--

Resolve the following errors in the migration or restore process of mysql database:

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'

Solution:

Modify mysql configuration file: max_allowed_packet=1024M

Restart mysql:

# systemctl restart mysql.service

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.