Linux: Борьба с новыми кодировками в mysql8

sudo gedit /etc/mysql/conf.d/mysql.cnf 

#и туда прописать

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8
default_authentication_plugin = mysql_native_password