Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 02 Feb 2006 15:40:14 -0900
From:      Peter Giessel <pgiessel@mac.com>
To:        Drew Tomlinson <drew@mykitchentable.net>
Cc:        FreeBSD Questions <freebsd-questions@freebsd.org>
Subject:   Re: Cracking MySQL Passwords
Message-ID:  <10181368.1138927214051.JavaMail.pgiessel@mac.com>
In-Reply-To: <43E2A280.5010803@mykitchentable.net>
References:  <43E2A280.5010803@mykitchentable.net>

next in thread | previous in thread | raw e-mail | index | archive | help
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;



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?10181368.1138927214051.JavaMail.pgiessel>