MySQL update from 4.1 to 4.7

[Eric S]

>From: Phillip Hocking <phill at adept.biz>
>Subject: MySQL update from 4.1 to 4.7 
>To: questions at freebsd.org
>
>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.
>  
>

I don't know the answer, but I know where to find it, since I 
encountered that same problem. When mysql starts up, it logs a message 
in the log file for that server to the effect that the password table 
needs to be updated, and includes the command to do just this.