From owner-freebsd-questions@FreeBSD.ORG Tue Dec 21 10:27:42 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 2E7F316A4CE for ; Tue, 21 Dec 2004 10:27:42 +0000 (GMT) Received: from male.aldigital.co.uk (male.thebunker.net [213.129.64.13]) by mx1.FreeBSD.org (Postfix) with ESMTP id 03E1443D31 for ; Tue, 21 Dec 2004 10:27:41 +0000 (GMT) (envelope-from m.seaman@infracaninophile.co.uk) Received: from gravitas.thebunker.net (gateway.ash.thebunker.net [213.129.64.4]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by male.aldigital.co.uk (Postfix) with ESMTP id 219AC97679; Tue, 21 Dec 2004 10:27:40 +0000 (GMT) Received: from [127.0.0.1] (localhost [127.0.0.1])iBLARcJ2067707; Tue, 21 Dec 2004 10:27:39 GMT (envelope-from m.seaman@infracaninophile.co.uk) Message-ID: <41C7FA95.3060209@infracaninophile.co.uk> Date: Tue, 21 Dec 2004 10:27:33 +0000 From: Matthew Seaman Organization: Infracaninophile User-Agent: Mozilla Thunderbird 1.0 (X11/20041213) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Noah References: <20041221063032.M20012@enabled.com> In-Reply-To: <20041221063032.M20012@enabled.com> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig34F58CD8796412622EF957C7" cc: freebsd-questions@freebsd.org 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 10:27:42 -0000 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--