MySQL update from 4.1 to 4.7

[Phillip Hocking]

Now it will not allow me to login to the database with any of the 
usernames that I remember here is the error in the log 2:58:29 [Warning] 
Found 4.1 style password for user 'root at localhost'. Ignoring user. You 
should change password for this user. How do I flush the tables to 
resolve this issue and change all the passwords around? Any help would 
be much appreciated.

Phill Hocking
Information Systems Manager
www.adept.biz