From owner-freebsd-questions@FreeBSD.ORG  Tue Feb  8 08:37:42 2005
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 7D43016A4CE
	for <freebsd-questions@freebsd.org>;
	Tue,  8 Feb 2005 08:37:42 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.195])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 02DC143D1F
	for <freebsd-questions@freebsd.org>;
	Tue,  8 Feb 2005 08:37:42 +0000 (GMT)
	(envelope-from normal1.lists@gmail.com)
Received: by wproxy.gmail.com with SMTP id 58so870837wri
	for <freebsd-questions@freebsd.org>;
	Tue, 08 Feb 2005 00:37:41 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
	s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding;
	b=Q9XexCsWaQX0U5C4V71iUP5VV3BWlpFHg7WzcFof+nsZRDunLrsjb8/RyvWM7ETG+ZHzFrhQfYWzzKw9dW5DxIsXZlVMbNoBig8PXNDrQfy+XPGTFgsIHRS7t+pXu4wMVFi74dcoa17vmzVW4JyDNUrpoHX7JggwqSVOKd62yco=
Received: by 10.54.43.67 with SMTP id q67mr31964wrq;
        Tue, 08 Feb 2005 00:37:40 -0800 (PST)
Received: by 10.54.2.45 with HTTP; Tue, 8 Feb 2005 00:37:40 -0800 (PST)
Message-ID: <efb8582050208003725c65654@mail.gmail.com>
Date: Tue, 8 Feb 2005 00:37:40 -0800
From: gabriel <normal1.lists@gmail.com>
To: freebsd-questions <freebsd-questions@freebsd.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Subject: Changing mysql root password
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: gabriel <normal1.lists@gmail.com>
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: Tue, 08 Feb 2005 08:37:42 -0000

Hello gang,

Okay so I've read the mysql docs and also googled my little heart out;
have also tried various solutions none of which worked. I've done a
fresh install of mysql3*-server from ports. The db dir is
/usr/local/mysql and I've been starting the deamon utilizing the
following line:
safe_mysqld --user=mysql --skip-grant-tables --err-log=/usr/local/mysql/erro.log

Okay, with that said, here's the output when trying to change root's
password (even mysql password);

gmpnoc# mysqladmin -h localhost -u root password password
mysqladmin: unable to change password; error: 'You must have
privileges to update tables in the mysql database to be able to change
passwords for others'
gmpnoc#

I've also tried it without -h, tried it with -h pointing to the actual
name of the machine. Nuffin!

Please someone enlighten me!

Cheers!

-- 
gabriel,

Member of:
FreeBSD-Announce
FreeBSD-Hardware
FreeBSD-Multimedia
FreeBSD-questions