ran into this issue in a 12.04 upgrade, my conf is spread across include
files based on usage.

I had this for 5.1 (note the two server settings):

/etc/mysql/conf.d$ cat charset.cnf                                              
                                                                                
         
[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8
default-character-set=utf8

[client]
default-character-set=utf8


sudo mysql service start - this would hang until sending a Ctrl+C

Changing to this allowed mysql to start, I guess the client entry is Ok.

/etc/mysql/conf.d$ cat charset.cnf                                              
                                                                                
         
[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8

[client]
default-character-set=utf8


Bit of a tough one, It's possible mysql (the vendor) issued notices about 
deprecated configuration but it would be good if the service start would not 
hang and instead issue a warning and die with log messages so a sysadmin knows 
what's happening.

I checked logs (syslog, mysql error log) and nothing showed up, thinking
AppArmor was the issue  - which has happened before - I uninstalled that
to test but no cigar. Reinstalled and the same issue.

If you hit this issue in a 12.04 upgrade, try out the charset conf
change  above.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/958120

Title:
  MySQL does not start with utf8 options

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/958120/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to