Date: Thu, 02 Feb 2006 16:58:02 -0800 From: Drew Tomlinson <drew@mykitchentable.net> To: Peter Giessel <pgiessel@mac.com> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: Cracking MySQL Passwords Message-ID: <43E2AA9A.5040205@mykitchentable.net> In-Reply-To: <10181368.1138927214051.JavaMail.pgiessel@mac.com> References: <43E2A280.5010803@mykitchentable.net> <10181368.1138927214051.JavaMail.pgiessel@mac.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 2/2/2006 4:40 PM Peter Giessel wrote: >On Thursday, February 02, 2006, at 03:24PM, Drew Tomlinson <drew@mykitchentable.net> wrote: > > > >>I'm frantically trying to recreate 3 users in the mysql.user table after >>accidentally deleting them. I have the names and the password hashes >>but don't know the password. >> >> > >Recreate then users with a different password then login to mysql as root and: > >use mysql; > >update user set Password="<password hash>" where User="<recreated user>"; > >flush privaleges; > > > Thank you very much. That should work! Drew -- Visit The Alchemist's Warehouse Magic Tricks, DVDs, Videos, Books, & More! http://www.alchemistswarehouse.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?43E2AA9A.5040205>