更改服务器变量character_set_server [英] Change server variable character_set_server

问题描述

我要将mysql服务器变量 character_set_server 更改为utf8。我已经搜索了这个，但似乎找不到我要找的信息或指令不匹配。
看来我需要编辑一个名为my.cnf的文件，但这个文件在我的系统上不存在。版本为5.1.36。

I want to change the mysql server variable character_set_server to utf8. I have googled on this but can't seem to find the information I'm looking for or the instructions don't match. It seems I need to edit a file called my.cnf but this file does not exist on my system. The version is 5.1.36.

推荐答案

运行此查询：

set global character_set_server = utf8;

然后重新启动mysql。
您可以使用一个简单的

then restart mysql. you can see the list of all your variables with a simple

show variables;

这篇关于更改服务器变量character_set_server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！