From owner-freebsd-questions@FreeBSD.ORG  Tue Dec 21 17:04:49 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 AB33F16A4CE
	for <freebsd-questions@freebsd.org>;
	Tue, 21 Dec 2004 17:04:49 +0000 (GMT)
Received: from typhoon.enabled.com (typhoon.enabled.com [216.218.220.21])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 8171C43D2D
	for <freebsd-questions@freebsd.org>;
	Tue, 21 Dec 2004 17:04:49 +0000 (GMT)
	(envelope-from admin2@enabled.com)
Received: from enabled.com (localhost.enabled.com [127.0.0.1])
	by typhoon.enabled.com (8.13.2/8.13.2) with ESMTP id iBLH4ia8058834;
	Tue, 21 Dec 2004 09:04:44 -0800 (PST)
	(envelope-from admin2@enabled.com)
From: "Noah" <admin2@enabled.com>
To: Matthew Seaman <m.seaman@infracaninophile.co.uk>
Date: Tue, 21 Dec 2004 09:04:44 -0800
Message-Id: <20041221170321.M47665@enabled.com>
In-Reply-To: <41C831D4.1060200@infracaninophile.co.uk>
References: <20041221063032.M20012@enabled.com>
	<20041221083201.9BB8D43D1F@mx1.FreeBSD.org> <20041221135400.M771@enabled.com>
	<41C831D4.1060200@infracaninophile.co.uk>
X-Mailer: Open WebMail 2.41 20040926
X-OriginatingIP: 67.161.56.189 (admin2)
MIME-Version: 1.0
Content-Type: text/plain;
	charset=iso-8859-1
cc: freebsd-questions@freebsd.org
Subject: Re: phpMyAdmin 2.6.1-rc1 cant create database
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: Tue, 21 Dec 2004 17:04:49 -0000


> 
> > I dont think that is the answer.  I forgot to add that root has all
privelegdes.
> 
> Remember that MySQL counts "root" @ "localhost" as a different 
> account to "root" @ "someotherhostname" -- and the question is,
>  which account are you actually using via phpMyAdmin?
> 
> 	Cheers,
> 
> 	Matthew


Here is what I am seeing from the priveledges.  I am seeing both a root
account for the localhost and a root account for the local_hostname - which is
the actually name of the machine.  WHat else shoudl I check here?


--- snip ---

 	root  	localhost  	Yes  	 ALL PRIVILEGES   	Yes  	Edit Privileges
	root 	<local_hostname> 	Yes 	ALL PRIVILEGES 	Yes 	Edit Privileges

--- snip ---

cheers,

Noah


> 
> -- 
> Dr Matthew J Seaman MA, D.Phil.                       8 Dane Court Manor
>                                                        School Rd
> PGP: http://www.infracaninophile.co.uk/pgpkey         Tilmanstone
> Tel: +44 1304 617253                                  Kent, CT14 0JL 
> UK