Date: Tue, 21 Dec 2004 10:27:33 +0000 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: Noah <admin2@enabled.com> Cc: freebsd-questions@freebsd.org Subject: Re: phpMyAdmin 2.6.1-rc1 cant create database Message-ID: <41C7FA95.3060209@infracaninophile.co.uk> In-Reply-To: <20041221063032.M20012@enabled.com> References: <20041221063032.M20012@enabled.com>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig34F58CD8796412622EF957C7
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Noah wrote:
>
> phpMyAdmin 2.6.1-rc1
> freeBSD-4.9
>
> phpMyAdmin claims that there are no priviledges to create a database even as
> root. how do I fix this?
All phpMyAdmin is doing is reporting what MySQL tells it. If you used
the mysql(1) command line interface from that account, you'll see
exactly the same problem.
You need to check the privilege settings within mysql to enable that
capability -- note that the capabilities functionality has been revised
and extended in recent MySQL releases so it's entirely possible that
even if you started out with root@yourhostname with ALL PRIVILEGES,
after a few upgrades, that account might be lacking a few new
privileges nowadays.
Cheers,
Matthew
--
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
--------------enig34F58CD8796412622EF957C7
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (FreeBSD)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iQCVAwUBQcf6mpr7OpndfbmCAQKeJwQAoBi0OQArg7L8pOlTT7JF25EMuaBs7nNj
0XqjSiWRH8tHSWQn2Me4yZv9BH2YBVziyF5g0dZc99WTkS3HlDUyxah2SX/r9iB6
0qgMPsBl7ZGvhUWwACeqf4N2KxfNtVvTaPp4L1dFF9S+MGX0x11f/8VgGmIN945X
MtsmXH5e1nM=
=Qj08
-----END PGP SIGNATURE-----
--------------enig34F58CD8796412622EF957C7--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41C7FA95.3060209>