From owner-freebsd-questions@FreeBSD.ORG  Sun Jun 20 19:06:15 2004
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 542DD16A4D3
	for <freebsd-questions@freebsd.org>;
	Sun, 20 Jun 2004 19:06:15 +0000 (GMT)
Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [204.127.202.55])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 0DD9D43D39
	for <freebsd-questions@freebsd.org>;
	Sun, 20 Jun 2004 19:06:15 +0000 (GMT)
	(envelope-from fbsd-questions@trini0.org)
Received: from hivemind.trini0.org (trini0.org[65.34.205.195])
          by comcast.net (sccrmhc11) with ESMTP
          id <2004062019061401100r7jeee>; Sun, 20 Jun 2004 19:06:14 +0000
Received: from gladiator.trini0.org (gladiator.trini0.org [192.168.0.3])
	by hivemind.trini0.org (Postfix) with ESMTP
	id 363EC16B; Sun, 20 Jun 2004 15:06:14 -0400 (EDT)
From: Gerard Samuel <fbsd-questions@trini0.org>
To: freebsd-questions@freebsd.org
Date: Sun, 20 Jun 2004 15:06:13 -0400
User-Agent: KMail/1.6.2
References: <3.0.6.32.20040620194842.007b72a0@mail.uk2.net>
In-Reply-To: <3.0.6.32.20040620194842.007b72a0@mail.uk2.net>
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <200406201506.13973.fbsd-questions@trini0.org>
cc: Graham Bentley <gbentley@uk2.net>
Subject: Re: MySQL Advice
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: Sun, 20 Jun 2004 19:06:15 -0000

On Sunday 20 June 2004 02:48 pm, Graham Bentley wrote:
> freebsd# /usr/local/bin/mysqladmin -u root -h freebsd.mydomain.com password
> mypassword
>
> /usr/local/bin/mysqladmin: connect to server at 'freebsd.mydomain.com'
> failed error: 'Host 'freebsd.mydomain.com' is not allowed to connect to
> this MySQL server'
>
> freebsd# /usr/local/bin/mysql --password

Im assuming you're talking about the error when trying to connect via 
mysqladmin.
Have you tried taking out the host option like ->
 /usr/local/bin/mysqladmin -u root password mypassword

Just a guess