Date: Mon, 31 Jan 2005 10:25:43 -0800 From: Eric S <ejs@americanlowlife.com> To: freebsd-questions@freebsd.org Subject: Re: MySQL update from 4.1 to 4.7 Message-ID: <41FE7827.9060201@americanlowlife.com> In-Reply-To: <20050130120119.09BBE16A4EB@hub.freebsd.org> References: <20050130120119.09BBE16A4EB@hub.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
>From: Phillip Hocking <phill@adept.biz> >Subject: MySQL update from 4.1 to 4.7 >To: questions@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@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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41FE7827.9060201>