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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs