Character-set-server and mysql configuration file

Question

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

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

In fact, in my my.cnf file, I configured it because I got a message when setting default-set-server=utf8 , which is now deprecated. Here is 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' 

Did anyone help?

Answer 1

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