From owner-freebsd-questions@FreeBSD.ORG  Fri Feb  3 00:40:16 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id CB66D16A420
	for <freebsd-questions@freebsd.org>;
	Fri,  3 Feb 2006 00:40:16 +0000 (GMT)
	(envelope-from pgiessel@mac.com)
Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.89])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 6C06043D48
	for <freebsd-questions@freebsd.org>;
	Fri,  3 Feb 2006 00:40:16 +0000 (GMT)
	(envelope-from pgiessel@mac.com)
Received: from mac.com (webmail15-en1 [10.13.10.141])
	by smtpout.mac.com (Xserve/8.12.11/smtpout02/MantshX 4.0) with ESMTP id
	k130eG4H015138; Thu, 2 Feb 2006 16:40:16 -0800 (PST)
Received: from webmail15 (localhost [127.0.0.1])
	by mac.com (Xserve/webmail15/MantshX 4.0) with ESMTP id k130eEY4028289; 
	Thu, 2 Feb 2006 16:40:15 -0800 (PST)
Message-ID: <10181368.1138927214051.JavaMail.pgiessel@mac.com>
Date: Thu, 02 Feb 2006 15:40:14 -0900
From: Peter Giessel <pgiessel@mac.com>
To: Drew Tomlinson <drew@mykitchentable.net>
in-reply-to: <43E2A280.5010803@mykitchentable.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
references: <43E2A280.5010803@mykitchentable.net>
X-Originating-IP: 158.145.111.132/instID=225
Cc: FreeBSD Questions <freebsd-questions@freebsd.org>
Subject: Re: Cracking MySQL Passwords
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 03 Feb 2006 00:40:16 -0000

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;