root@ubuntu:~# service mysql start start: Job failed to start root@ubuntu:~# root@ubuntu:~# cat /var/log/mysql/error.log 121125 17:07:38 [Note] Plugin 'FEDERATED' is disabled. 121125 17:07:38 InnoDB: The InnoDB memory heap is disabled 121125 17:07:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins 121125 17:07:38 InnoDB: Compressed tables use zlib 1.2.3.4 121125 17:07:38 InnoDB: Initializing buffer pool, size = 128.0M 121125 17:07:38 InnoDB: Completed initialization of buffer pool 121125 17:07:38 InnoDB: highest supported file format is Barracuda. 121125 17:07:39 InnoDB: Waiting for the background threads to start 121125 17:07:40 InnoDB: 1.1.8 started; log sequence number 2054581 121125 17:07:40 [ERROR] /usr/sbin/mysqld: unknown variable 'default-character-set=utf8' 121125 17:07:40 [ERROR] Aborting
121125 17:07:40 InnoDB: Starting shutdown... 121125 17:07:40 InnoDB: Shutdown completed; log sequence number 2054581 121125 17:07:40 [Note] /usr/sbin/mysqld: Shutdown complete ------------- it seems that [mysqld] don't support variable 'default-character-set=utf8' again. but character-set-server=utf8 works. so it seems not a bug, i think. I will not renew this report. below is my configure to support utf8: [client] default-character-set=utf8 [mysqld] init_connect='SET collation_connection = utf8_unicode_ci' init_connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake thank you! andy zhou http://abloz.com ** Changed in: mysql-5.5 (Ubuntu) Status: Incomplete => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1081675 Title: ubuntu 12.04 mysql5.5 support utf8 problem To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1081675/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs