After update mysql to 5.0.18 (I tried 5.0.19 as well) mysqlclient no longer look for my.cnf in /etc/mysql. All connection charset fall back to latin1(I specify all connect to utf8). After cp my.cnf from /etc/mysql to /etc and then it works again. when I run mysql --help it shows -------------------------------------------------- Default options are read from the following files in the given order: /etc/my.cnf ~/.my.cnf -------------------------------------------------- Previously it is -------------------------------------------------- Default options are read from the following files in the given order: /etc/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf -------------------------------------------------- The strange thing is that there is no my.cnf in all three directory neither. However it works.
*** Bug 127807 has been marked as a duplicate of this bug. ***
This is fixed now with 5.0.19-r1. Best regards, CHTEKK.