From owner-freebsd-questions@FreeBSD.ORG  Fri Feb  3 00:58:05 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 D2FD916A420
	for <freebsd-questions@freebsd.org>;
	Fri,  3 Feb 2006 00:58:05 +0000 (GMT)
	(envelope-from drew@mykitchentable.net)
Received: from relay01.roc.ny.frontiernet.net (relay01.roc.ny.frontiernet.net
	[66.133.182.164])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 79F1643D46
	for <freebsd-questions@freebsd.org>;
	Fri,  3 Feb 2006 00:58:05 +0000 (GMT)
	(envelope-from drew@mykitchentable.net)
Received: from blacklamb.mykitchentable.net
	(70-97-220-126.dsl2.elk.ca.frontiernet.net [70.97.220.126])
	by relay01.roc.ny.frontiernet.net (Postfix) with ESMTP id 6554C364098; 
	Fri,  3 Feb 2006 00:58:03 +0000 (UTC)
Received: from [192.168.25.6] (unknown [192.168.25.6])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by blacklamb.mykitchentable.net (Postfix) with ESMTP id 1A817AE6F4;
	Thu,  2 Feb 2006 16:58:02 -0800 (PST)
Message-ID: <43E2AA9A.5040205@mykitchentable.net>
Date: Thu, 02 Feb 2006 16:58:02 -0800
From: Drew Tomlinson <drew@mykitchentable.net>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Peter Giessel <pgiessel@mac.com>
References: <43E2A280.5010803@mykitchentable.net>
	<10181368.1138927214051.JavaMail.pgiessel@mac.com>
In-Reply-To: <10181368.1138927214051.JavaMail.pgiessel@mac.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new-2.3.2 (20050629) at
	filter10.roc.ny.frontiernet.net
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:58:05 -0000

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