如何设置默认字符集? [英] How to set the default character-set?

问题描述

我想在mysql中创建一个新的数据库. 我将utf8设置为默认字符集，但是当我尝试重新启动db时，mysql无法重新启动并显示以下提示:

I want to create a new db in mysql. I set utf8 as the default-character-set, but when I attempted to restart the db, mysql failed to restart and posted the following prompt:

尝试启动服务器... 无法重新连接到MySQL服务器. 服务器无法启动.

Trying to start the server ... Could not re-connect to the MySQL Server. Server could not be started.

插件'FEDERATED'已禁用.

Plugin 'FEDERATED' is disabled.

C:\ Program Files \ MySQL \ MySQL Server 5.5 \ bin \ mysqld:未知变量'default-character-set = utf8'

C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: unknown variable 'default-character-set=utf8'

正在中止

C:\ Program Files \ MySQL \ MySQL Server 5.5 \ bin \ mysqld:关闭完成

C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

我知道取消默认字符集后，mysql将重新启动.但是如果我必须设置默认字符集，还有其他方法可以使mysql重新工作吗?

I know that after cancelling the default-character-set, mysql will restart. But if I had to set the default-character-set, is there some other way to make mysql work again?

推荐答案

我遇到了类似的问题.正如EO2指出的那样，答案是在5.5中弃用了default-character-set.您应该改用:

I had a similar problem. The answer, as EO2 pointed out, is that default-character-set is deprecated in 5.5. You should use instead:

character-set-server = utf8

顺便说一句，最好将答案回答为答案，而不是评论...;-)

BTW, it's better if answers are answered as answers, not comments... ;-)

这篇关于如何设置默认字符集?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！