how can I make default Database creation utf-8

[ibrothers]

I want when I go on and create Database the default is utf-8
where do I change the setting?

 

[BestBoard]

edit /etc/my.cnf and add default-character-set = xxx (utf8 in your case)

 

[Scolpy]

edit /etc/my.cnf and add default-character-set = xxx (utf8 in your case)

He also need to select the collation server.

Under [mysqld] section, add those lines:

character_set_server = utf8
collation_server = utf8_general_ci

then, restart mysqld service(service mysqld restart).

 

[netwayhost]

Thanks for your suggestion