MySQL update from 4.1 to 4.7

Eric S ejs at
Mon Jan 31 10:25:45 PST 2005

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

More information about the freebsd-questions mailing list