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

2 Answers 2


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! http://dev.mysql.com/doc/refman/5.0/en/create-database.html


See this, this and this...

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .