set mysql to utf8 encoding_mysql set encoding utf8-优快云博客

本文指导您如何升级MySQL至5.5.12版本并解决默认字符集utf8引起的启动问题，通过移除相关配置指令，确保配置文件正确设置字符集，并验证MySQL是否已成功切换至UTF8编码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

70 down vote

For recent version of MySQL

default-character-set = utf8

causes a problem, it's deprecated I think.

as Justin Ball says in "Upgrade to MySQL 5.5.12 and now MySQL won’t start, you should:

Remove that directive and you should be good.

Then your configuration file ('/etc/my.cnf' for example) should look like that:

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

Restart MySQL.

For making sure, your MySQL is UTF8, Run the following queries in your MySQL prompt:

First query:

 mysql> show variables like 'char%';

The output should look like:

 +--------------------------+---------------------------------+
 | Variable_name            | Value                           |
 +--------------------------+---------------------------------+
 | character_set_client     | utf8                            |
 | character_set_connection | utf8                            |
 | character_set_database   | utf8                            |
 | character_set_filesystem | binary                          |
 | character_set_results    | utf8                            |
 | character_set_server     | utf8                            |
 | character_set_system     | utf8                            |
 | character_sets_dir       | /usr/local/mysql/share/charsets/|
 +--------------------------+---------------------------------+

Second query:

 mysql> show variables like 'collation%';

and the query output is

 +----------------------+-----------------+
 | Variable_name        | Value           |
 +----------------------+-----------------+
 | collation_connection | utf8_general_ci |
 | collation_database   | utf8_unicode_ci |
 | collation_server     | utf8_unicode_ci |
 +----------------------+-----------------+

Changing the existed database to the utf8 encoding:

Use the ALTER DATABASE and ALTER TABLE commands.

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE tablename CHARACTER SET utf8 COLLATE utf8_general_ci;