From owner-freebsd-questions@FreeBSD.ORG  Wed May 28 04:27:02 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 4599837B401
	for <freebsd-questions@freebsd.org>;
	Wed, 28 May 2003 04:27:01 -0700 (PDT)
Received: from perimeter.co.za (obelix.perimeter.co.za [209.212.102.154])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 8564543F75
	for <freebsd-questions@freebsd.org>;
	Wed, 28 May 2003 04:26:58 -0700 (PDT)
	(envelope-from bsd@perimeter.co.za)
Received: from PATRICK (gateway.mip.co.za [209.212.102.245])
  (AUTH: LOGIN bsd@perimeter.co.za)
  by perimeter.co.za with esmtp; Wed, 28 May 2003 13:26:40 +0200
Message-ID: <004e01c3250c$0231f6d0$b50d030a@mip.co.za>
From: "Patrick O'Reilly" <bsd@perimeter.co.za>
To: freebsd-questions@freebsd.org
References: <001701c32508$1e9679d0$b50d030a@mip.co.za>
Date: Wed, 28 May 2003 13:26:35 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
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 11:27:02 -0000

----- Original Message -----
From: "Patrick O'Reilly" <bsd@perimeter.co.za>

> Hi all.
>
> Does anyone know if there is a special trick to setting the mysql root
> user's password after installing mysql323-server on FreeBSD?
>
> I've done like the manuals say (mysqladmin -uroot password xyz), but
all
> I get is:
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>
> I don't remember any passwords being set during the installation....
>

Thanks all for your replies.

I realised I must have broken something, so I reinstalled the port and
now it is behaving...

Regards,
Patrick.