character-set-server and mysql's config file

Question

I am running mysql -u root -p (on Ubuntu 12.05), and I keep on getting this error message:

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

Indeed in my my.cnf file I set it up because I had a message occurring when setting default-set-server=utf8 which is now deprecated. Here's my my.cnf file:

[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'

Could anybody help?

Answer 1

you need to remove character-set-server = utf8 under client you already have one for in [mysqld] and make sure to restart the SID after changing the cnf file