homepage Welcome to WebmasterWorld Guest from 54.161.246.212
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Extra characters appeared in columns priv table after upgrade
Tyskie



 
Msg#: 4185881 posted 9:48 am on Aug 12, 2010 (gmt 0)

Hello,

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!

Thanks

 

coopster

WebmasterWorld Administrator coopster us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4185881 posted 12:06 pm on Aug 15, 2010 (gmt 0)

Welcome to WebmasterWorld, Tyskie.

You may need to run the mysql_upgrade command [dev.mysql.com] for your version of MySQL if you haven't yet. Read the whole page before beginning and be certain to do a backup first, just in case.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved