The right way to create database for Django - collation error

The right way to create a database

Refer to 

• django-python-collation-error/7083511#7083511
• fix-django-illegal-mix-of-collations
  

When creating a new database, remember to create with the right collate settings:

CREATE DATABASE foo CHARACTER SET utf8 COLLATE utf8_general_ci;

Change MySQL default character set to UTF-8 in my.cnf? 

Error Number: 1267

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Solutions refer to :

• Illegal mix of collations MySQL Error
• Change MySQL default character set to UTF-8 in my.cnf?

config on /etc/my.cnf

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8