sudo gedit /etc/mysql/conf.d/mysql.cnf
#as
[mysql]
default-character-set=utf8
sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf
#as
[mysqld]
character-set-server=utf8
lower_case_table_names=1
sudo gedit /etc/mysql/conf.d/mysql.cnf
#as
[mysql]
default-character-set=utf8
sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf
#as
[mysqld]
character-set-server=utf8
lower_case_table_names=1