MySQL Bugs: #5675: Unable to select user in User Administration

Bug #5675	Unable to select user in User Administration
Submitted:	20 Sep 2004 20:34	Modified:	11 Oct 2004 9:37
Reporter:	Wolf Butler	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.0.12	OS:	Windows (Windows XP Pro)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
This was previously reported in closed bug #4415, which was closed as fixed in July.

The server is: 4.1.4-gamma-standard on Linux (RH9)

When attempting to select a user in User Administration, I get the following in a pop-up error dialog:

Error while fetch user information.
MySQL Error Nr. 1267
Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
operation '='

How to repeat:
Connect to server and select User Administration option.
Click on user name.

Just wanted to add...

This is on a NEW install MySQL 4.1, not an upgraded previous install or migration. If there is a problem with the grant tables themselves, it was the result of a problem with the mysql_install_db script.

This appears to be fixed with latest build of MySQL:
MySQL Standard: 4.1.5 gamma

Perhaps it was a problem with the grant tables.

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

It's the same bug as 
http://bugs.mysql.com/bug.php?id=5957

Actually character set of system tables was changed in the latest version of
mysql, and it became the reason of the bug.

We fixed the bug in the source repository, and will 
add note to the manual soon

(http://bugs.mysql.com/bug.php?id=6014)