title: character-set-server and mysql's config file
body: <p>I am running <code>mysql -u root -p</code> (on Ubuntu 12.05), and I keep on getting this error message:</p>
  
  <pre><code>mysql: unknown variable 'character-set-server=utf8'
  </code></pre>
  
  <p>Indeed in my <code>my.cnf</code> file I set it up because I had a message occurring when setting <code>default-set-server=utf8</code> which is now deprecated. Here's my <code>my.cnf</code> file:</p>
  
  <pre><code>[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'
  </code></pre>
  
  <p>Could anybody help?</p>