From owner-freebsd-questions@FreeBSD.ORG  Sat Sep 20 07:26:53 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 34AB916A4B3
	for <freebsd-questions@freebsd.org>;
	Sat, 20 Sep 2003 07:26:53 -0700 (PDT)
Received: from bacon.truedestiny.net (dsl159.iae.nl [212.61.62.160])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3E9A743FBF
	for <freebsd-questions@freebsd.org>;
	Sat, 20 Sep 2003 07:26:52 -0700 (PDT)
	(envelope-from janvs@truedestiny.net)
Received: from localhost (localhost.truedestiny.net [127.0.0.1])
	by bacon.truedestiny.net (Postfix) with ESMTP
	id B9A3D598B; Sat, 20 Sep 2003 16:27:56 +0200 (CEST)
Received: by bacon.truedestiny.net (Postfix, from userid 1001)
	id BEBC95989; Sat, 20 Sep 2003 16:27:55 +0200 (CEST)
Date: Sat, 20 Sep 2003 16:27:55 +0200
From: Jan van Stekelenburg <janvs@truedestiny.net>
To: Shawn Guillemette <shawn@guillemette.org>
Message-ID: <20030920142755.GA961@bacon.truedestiny.net>
References: <000801c37f8f$9e557f40$0401a8c0@hsdlaptop>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <000801c37f8f$9e557f40$0401a8c0@hsdlaptop>
X-URL: http://www.truedestiny.net/
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by AMaViS snapshot-20020422
cc: freebsd-questions@freebsd.org
Subject: Re: error with mysql when doing mysql -u root
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: Sat, 20 Sep 2003 14:26:53 -0000

On Sat, Sep 20, 2003 at 08:55:30AM -0700, Shawn Guillemette wrote:
> After setting the mysql root user passwd I get this when trying to log in. 
> 
> # mysql -u root
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

You forgot the -p option.
For more info: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Connecting-disconnecting

Also reading man-pages never hurt. ;-)

Jan.