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>