From owner-freebsd-questions@FreeBSD.ORG Mon Apr 5 02:05:39 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 6481B16A4CF for ; Mon, 5 Apr 2004 02:05:39 -0700 (PDT) Received: from smtp.infracaninophile.co.uk (smtp.infracaninophile.co.uk [81.2.69.218]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0F4C543D1F for ; Mon, 5 Apr 2004 02:05:38 -0700 (PDT) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost.infracaninophile.co.uk [IPv6:::1])i3595A32068597 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 5 Apr 2004 10:05:11 +0100 (BST) (envelope-from matthew@happy-idiot-talk.infracaninophile.co.uk) Received: (from matthew@localhost)id i3595AJl068596; Mon, 5 Apr 2004 10:05:10 +0100 (BST) (envelope-from matthew) Date: Mon, 5 Apr 2004 10:05:10 +0100 From: Matthew Seaman To: Noah Message-ID: <20040405090510.GA56728@happy-idiot-talk.infracaninophile.co.uk> Mail-Followup-To: Matthew Seaman , Noah , freebsd-questions@freebsd.org References: <20040405081454.M1983@enabled.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="OXfL5xGRrasGEqWY" Content-Disposition: inline In-Reply-To: <20040405081454.M1983@enabled.com> User-Agent: Mutt/1.5.6i X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on happy-idiot-talk.infracaninophile.co.uk X-Virus-Scanned: clamd / ClamAV version devel-20040323, clamav-milter version 0.70a cc: freebsd-questions@freebsd.org Subject: Re: phpmyadmin - users not seeing specific 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: Mon, 05 Apr 2004 09:05:39 -0000 --OXfL5xGRrasGEqWY Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Apr 05, 2004 at 12:21:59AM -0800, Noah wrote: > I set the $cfg['Servers'][$i]['auth_type'] to cookie so users definitely = get > the login. but when I login with a user other than root. I find that I = am > able to veiw all the databases that root could view. I was assuming with= the > multiuser functionality that users could only view databases for which th= ey > have granted access to. is there something else i need to configure here? Well, the 'cookie' mode just exposes the internal mysql authentication and access control via the web. Works very well for me. =20 Can you verify that your users have the correct privilege GRANTs within the database -- ie. specifically can you use mysql(1)'s command line to log in as those users and access bits of the database you shouldn't be able to? Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks Savill Way PGP: http://www.infracaninophile.co.uk/pgpkey Marlow Tel: +44 1628 476614 Bucks., SL7 1TH UK --OXfL5xGRrasGEqWY Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQFAcSFGdtESqEQa7a0RAv2sAJ98uaBmG4WrCiBdFJSjlcGgaDVdXwCdFiEM OyzrsyQOmBR85kOj/cevVNA= =8mBH -----END PGP SIGNATURE----- --OXfL5xGRrasGEqWY--