Date: Tue, 21 Dec 2004 15:39:17 +0100 From: martin hudec <corwin@aeternal.net> To: freebsd-questions@freebsd.org Subject: Re: phpMyAdmin 2.6.1-rc1 cant create database Message-ID: <20041221143917.GC871@pleiades.aeternal.net> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
--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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20041221143917.GC871>