[Solved] MySQL ERROR 1231 (42000):Variable 'character_set_client' can't be set to the value of 'NULL'

Updated: 24th December 2019
Tags: sql mysql

If you try to import dumped file, and there is such an error, try using mysql console with options and then import sql file

mysql -u root -p --max_allowed_packet=6400M

Troubleshoot

If you haven’t acess to console or the previous doesn’t work

set global max_allowed_packet=10000000000;