character-set-server和mysql的配置文件

Question

我正在运行mysql -u root -p (在Ubuntu12.05上)，并且我一直收到这个错误消息：

mysql: unknown variable 'character-set-server=utf8'

实际上，我之所以在my.cnf文件中设置它，是因为在设置default-set-server=utf8时出现了一条消息，该消息现在已被弃用。这是我的my.cnf文件：

[client]
  port            = 3306
  socket          = /var/run/mysqld/mysqld.sock
  character-set-server = utf8
[mysqld]
  #
  # * Basic Settings
  #
  user            = mysql
  pid-file        = /var/run/mysqld/mysqld.pid
  socket          = /var/run/mysqld/mysqld.sock
  port            = 3306
  basedir         = /usr
  datadir         = /var/lib/mysql
  tmpdir          = /tmp
  skip-external-locking
  collation-server = utf8_unicode_ci
  character-set-server = utf8
  init-connect='SET NAMES utf8'

有人能帮上忙吗？

Answer 1

您需要删除[mysqld]中已有的client下的character-set-server = utf8，并确保在更改cnf文件后重新启动SID