[Bug 1081675] Re: ubuntu 12.04 mysql5.5 support utf8 problem
ablo
1081675 at bugs.launchpad.net
Sun Nov 25 09:17:23 UTC 2012
root at ubuntu:~# service mysql start
start: Job failed to start
root at ubuntu:~#
root at 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
Server Team, which is subscribed to mysql-5.5 in 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
More information about the Ubuntu-server-bugs
mailing list