From owner-freebsd-questions@FreeBSD.ORG  Wed May 28 08:59:28 2003
Return-Path: <owner-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 4C9EB37B413
	for <freebsd-questions@freebsd.org>;
	Wed, 28 May 2003 08:59:28 -0700 (PDT)
Received: from postalley.nic.cc (postalley.nic.cc [206.253.214.200])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 689C243F93
	for <freebsd-questions@freebsd.org>;
	Wed, 28 May 2003 08:59:27 -0700 (PDT)	(envelope-from mark@foster.cc)
Received: from ip-216-73-140-100.vantas.net ([216.73.140.100]
	helo=gentoo1.lan.enic.cc)
	by postalley.nic.cc with asmtp (Exim 3.35 #1)	id 19L3Kp-00072S-00
	for freebsd-questions@freebsd.org; Wed, 28 May 2003 08:59:27 -0700
From: Mark Foster <mark@foster.cc>
To: freebsd-questions@freebsd.org
In-Reply-To: <87u1bfwcry.fsf@penthesilea.fte.local>
References: <001701c32508$1e9679d0$b50d030a@mip.co.za>
	 <87u1bfwcry.fsf@penthesilea.fte.local>
Content-Type: text/plain
Organization: 
Message-Id: <1054137454.7327.15.camel@gentoo1.enic.cc>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.2- 
Date: 28 May 2003 08:57:34 -0700
Content-Transfer-Encoding: 7bit
Subject: Re: mysql root user
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
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: Wed, 28 May 2003 15:59:28 -0000

The secret is starting mysqld with --skip-grant-tables, then resetting.
http://www.mysql.com/doc/en/Resetting_permissions.html

On Wed, 2003-05-28 at 04:06, Frank Tegtmeyer wrote:
> "Patrick O'Reilly" <bsd@perimeter.co.za> writes:
> 
> > I've done like the manuals say (mysqladmin -uroot password xyz), but all
> 
> Either use:
> mysqladmin -uroot --password=xyz
> 
> or
> mysqladmin -uroot -p
> 
> > I don't remember any passwords being set during the installation....
> 
> Then you would have to follow the FAQ to set a new one without knowing
> the old.
> 
> Regards, Frank
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
-- 
-mdf [Mark D. Foster]	http://mark.foster.cc/