Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like our centOS server 's mysql setup to use utf8 by default.

Can you tell me which file(s) need to be configured and how?

I know it's a pretty vague question but i'm not familiar with server management. Let me know if you need more details.

Thank you

share|improve this question
up vote 2 down vote accepted

At compile time use --with-charset=utf8 and --with-collation=utf8_general_ci options to configure.

When creating database or table use DEFAULT CHARACTER SET utf8.

It's in the manual!

share|improve this answer

See this, this and this...

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.