Msg#: 4185881 posted 9:48 am on Aug 12, 2010 (gmt 0)
We recently upgraded from MySQL 4 to 5, and as a result the mysql.columns_priv table now has loads of '�'(black diamond with ? in it) in phpmyadmin, and '|' in MySQL Query Browser, after all the values, except 'Timestamp', and 'Colimn_prive' columns.
There are few with out this, but they were added after the upgrade. Also when using command line there are no extra characters, but using 'where Host = 'localhost' it only returns the new entries that do show the extra characters in phpmyadmin.
I have flushed, and repaired the table but this has not achieved anything.
what can we do to remove the '�'(black diamond with ? in it), ideally with out having to add all the permissions again!