default db collation

I want all databases to be created by default with utf-8 collation.
Where can I change the default collation?

 

You can do so in /etc/mysql/my.cnf
Just add this lines to [mysqld] section, so it looks like:

Code:

[mysqld]
# utf-8
init-connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
default-character-set=utf8
default-collation=utf8_general_ci
# end utf-8
.
.
.
the rest here...