From owner-freebsd-questions@FreeBSD.ORG Tue Dec 21 17:06:49 2004 Return-Path: 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 62AE216A4CE for ; Tue, 21 Dec 2004 17:06:49 +0000 (GMT) Received: from typhoon.enabled.com (typhoon.enabled.com [216.218.220.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 457C343D48 for ; Tue, 21 Dec 2004 17:06: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 iBLH6aQ7058905; Tue, 21 Dec 2004 09:06:36 -0800 (PST) (envelope-from admin2@enabled.com) From: "Noah" To: martin hudec , freebsd-questions@freebsd.org Date: Tue, 21 Dec 2004 09:06:36 -0800 Message-Id: <20041221170523.M77617@enabled.com> In-Reply-To: <20041221143917.GC871@pleiades.aeternal.net> References: <20041221063032.M20012@enabled.com> <20041221083201.9BB8D43D1F@mx1.FreeBSD.org> <20041221135400.M771@enabled.com> <41C831D4.1060200@infracaninophile.co.uk> <20041221143917.GC871@pleiades.aeternal.net> 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 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 21 Dec 2004 17:06:49 -0000 On Tue, 21 Dec 2004 15:39:17 +0100, martin hudec wrote > Hello, > > On Tue, Dec 21, 2004 at 02:23:16PM +0000 or thereabouts, Matthew > Seaman wrote: > > >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? > > > > Maybe you're right. I am experiencing this behavior while using MySQL > 4.0.22. On other databases using older 4.0.20 there are no > differences between local super user and remote super user. I am > using remote phpmyadmin user with ALL PRIVILEGES set to him and I > am not able to create databases or reload mysql while accessing 4.0.22. > Also I am experiencing that MySQL is no longer doing IP resolving, > so I have to use IP address instead of hostname for > authentication purposes (but this is okay, at least I am not > depending on another service for resolving the IP). > Hi, Ive had this same behavior during older versions of mysql even at version 4.0.20 and before. These are different symptoms mentioned above that have nothing to do with my issue. cheers, Noah > Cheers, > > Martin > > -- > martin hudec > > * 421 907 303 393 > * corwin@aeternal.net > * http://www.aeternal.net > > "Nothing travels faster than the speed of light with the possible > exception of bad news, which obeys its own special laws." > > Douglas Adams, "The Hitchhiker's Guide to the Galaxy"