From owner-freebsd-questions@FreeBSD.ORG Tue Dec 21 14:23:31 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 DFD8816A4CE for ; Tue, 21 Dec 2004 14:23:31 +0000 (GMT) Received: from male.aldigital.co.uk (male.thebunker.net [213.129.64.13]) by mx1.FreeBSD.org (Postfix) with ESMTP id 153F143D49 for ; Tue, 21 Dec 2004 14:23:29 +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 160D5977FC; Tue, 21 Dec 2004 14:23:24 +0000 (GMT) Received: from [127.0.0.1] (localhost [127.0.0.1])iBLENLh3068337; Tue, 21 Dec 2004 14:23:21 GMT (envelope-from m.seaman@infracaninophile.co.uk) Message-ID: <41C831D4.1060200@infracaninophile.co.uk> Date: Tue, 21 Dec 2004 14:23:16 +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> <20041221083201.9BB8D43D1F@mx1.FreeBSD.org> <20041221135400.M771@enabled.com> In-Reply-To: <20041221135400.M771@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="------------enig0A9EE66F94500C4424025639" cc: Andras Kende 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 14:23:32 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig0A9EE66F94500C4424025639 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Noah wrote: > On Tue, 21 Dec 2004 02:32:06 -0600, Andras Kende wrote > >>-----Original Message----- >>From: owner-freebsd-questions@freebsd.org >>[mailto:owner-freebsd-questions@freebsd.org] On Behalf Of Noah >>Sent: Tuesday, December 21, 2004 12:31 AM >>To: freebsd-questions@freebsd.org >>Subject: phpMyAdmin 2.6.1-rc1 cant create database >> >>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? >>That's probably more like a mysql privilege problem... >>Welcome to phpMyAdmin 2.6.1-rc1 MySQL 4.0.22 running on localhost as >>root@localhost, tested to create new db works fine here... >> >>Do you have something like this in your privileges: >> >>phpMyAdmin -> Home -> Privileges : >> >>root localhost Yes ALL PRIVILEGES Yes > I dont think that is the answer. I forgot to add that root has all privelegdes. Remember that MySQL counts "root" @ "localhost" as a different account to "root" @ "someotherhostname" -- and the question is, which account are you actually using via phpMyAdmin? 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 --------------enig0A9EE66F94500C4424025639 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 iQCVAwUBQcgx2Zr7OpndfbmCAQKkHQP/ebc2F9+ocK9t3L44uedso6wN5iULYQ1J gWjBAe7QlawM8uSiT/PRPdA5ZRD6sNnWtUADpUKjqQruhHjJsO4e401c4X23K6lJ dLR+7xEZcoYB58WBL1i1OdcJvM3rWTUr4pH5C6J74ac7WYSVmSDhmXc6nLAWNyDi +2whoaze3f4= =IAnR -----END PGP SIGNATURE----- --------------enig0A9EE66F94500C4424025639--