How to install utf-8 as a standard character set for mysql server?

Question

Do I need to recompile it?

I understood various ways to set character set values, see

http://dev.mysql.com/doc/refman/5.5/en/charset.html

but starting with other values ​​or my.cnf settings nothing has changed. Because if I do this:

sudo mysqld --verbose --help | grep charact

it always answers me latin1 as standard encoding. the system is an ubuntu lts server with a standard mysql installation.

Answer 1

Decision:

add this to my.cnf:

[mysqld] character-set-server=utf8 character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysql] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqladmin] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlcheck] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqldump] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlimport] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlshow] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 #end 

Answer 2

 [mysqld] collation-server = utf8_unicode_ci init-connect='SET NAMES utf8' character-set-server = utf8 skip-character-set-client-handshake [client] default-character-set = utf8 [mysql] default-character-set = utf8 

UPDATE: Currently, you should probably use utf8mb4.

Answer 3

Create the file /etc/mysql/conf.d/mysqld.cnf with the contents:

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

If you omit the mapping server, it must be configured to utf8_general_ci.

I tested this configuration with MySQL 5.6 on Ubuntu 15.04.