From owner-freebsd-questions@FreeBSD.ORG Tue Dec 21 14:39:21 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 C8C6916A4CE for ; Tue, 21 Dec 2004 14:39:21 +0000 (GMT) Received: from amber.aeternal.net (amber.in.markiza.sk [62.168.76.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0324543D2F for ; Tue, 21 Dec 2004 14:39:21 +0000 (GMT) (envelope-from corwin@pleiades.aeternal.net) Received: from localhost (localhost.aeternal.net [127.0.0.1]) by amber.aeternal.net (Postfix) with ESMTP id 1CE9AB83D for ; Tue, 21 Dec 2004 15:41:41 +0100 (CET) Received: from amber.aeternal.net ([127.0.0.1]) by localhost (amber.aeternal.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 54641-01 for ; Tue, 21 Dec 2004 15:41:40 +0100 (CET) Received: from pleiades.aeternal.net (pleiades.markiza.sk [192.168.0.7]) by amber.aeternal.net (Postfix) with ESMTP id F1256B818 for ; Tue, 21 Dec 2004 15:41:39 +0100 (CET) Received: from pleiades.aeternal.net (localhost.aeternal.net [127.0.0.1]) by pleiades.aeternal.net (Postfix) with ESMTP id B25B17E862 for ; Tue, 21 Dec 2004 15:39:18 +0100 (CET) Received: (from corwin@localhost) by pleiades.aeternal.net (8.13.1/8.13.1/Submit) id iBLEdH1H048092 for freebsd-questions@freebsd.org; Tue, 21 Dec 2004 15:39:17 +0100 (CET) (envelope-from corwin) Date: Tue, 21 Dec 2004 15:39:17 +0100 From: martin hudec To: freebsd-questions@freebsd.org Message-ID: <20041221143917.GC871@pleiades.aeternal.net> References: <20041221063032.M20012@enabled.com> <20041221083201.9BB8D43D1F@mx1.FreeBSD.org> <20041221135400.M771@enabled.com> <41C831D4.1060200@infracaninophile.co.uk> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="2/5bycvrmDh4d1IB" Content-Disposition: inline In-Reply-To: <41C831D4.1060200@infracaninophile.co.uk> X-Copyright: (C) 2004 Martin Hudec X-Operating-System: FreeBSD pleiades.aeternal.net 6.0-CURRENT i386 X-PGP-Key: http://www.aeternal.net/corwin_aeternal.asc User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at aeternal.net Subject: Re: phpMyAdmin 2.6.1-rc1 cant create database X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: martin hudec List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 21 Dec 2004 14:39:21 -0000 --2/5bycvrmDh4d1IB Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello, On Tue, Dec 21, 2004 at 02:23:16PM +0000 or thereabouts, Matthew Seaman wro= te: > >I dont think that is the answer. I forgot to add that root has all=20 > >privelegdes. >=20 > Remember that MySQL counts "root" @ "localhost" as a different account=20 > to "root" @ "someotherhostname" -- and the question is, which account=20 > are you actually using via phpMyAdmin? >=20 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). Cheers, Martin =20 --=20 martin hudec * 421 907 303 393 * corwin@aeternal.net * http://www.aeternal.net "Nothing travels faster than the speed of light with the possible=20 exception of bad news, which obeys its own special laws." Douglas Adams, "The Hitchhiker's Guide to the Galaxy" --2/5bycvrmDh4d1IB Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (FreeBSD) iD8DBQFByDWVZYEZIv+rgggRApUoAJ9vHDkw9YaWZvZh0QfrHLhJHaZslQCghxXk opu4KzvIbJsCFxXHnBnM658= =rk6X -----END PGP SIGNATURE----- --2/5bycvrmDh4d1IB--