[Bug 1081675] Re: ubuntu 12.04 mysql5.5 support utf8 problem
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
[Bug 1081675] Re: ubuntu 12.04 mysql5.5 support utf8 problem
Thank you for taking the time to report this bug and helping to make Ubuntu better. The lack of error log is bug 1014732 and an update should be available for it soon. In the meantime, you can manually add: log_error = /var/log/mysql/error.log to /etc/mysql/my.cnf. Please could you do that, reproduce the failure and then attach the generated error log? Also, I'm not quite sure I understand why this is a bug in the first place, if you are able to configure UTF-8 in a different way. Is this first way of trying it supposed to work, and where is that documented please? Once you've replied, please change the bug status back to New. ** Changed in: mysql-5.5 (Ubuntu) Status: New => Incomplete -- 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