From owner-freebsd-questions@FreeBSD.ORG Mon Apr 5 03:56:19 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 82D0216A4CE for ; Mon, 5 Apr 2004 03:56:19 -0700 (PDT) Received: from typhoon.enabled.com (typhoon.enabled.com [216.218.220.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7434043D4C for ; Mon, 5 Apr 2004 03:56:19 -0700 (PDT) (envelope-from admin2@enabled.com) Received: from enabled.com (localhost.enabled.com [127.0.0.1]) by typhoon.enabled.com (8.12.11/8.12.11) with ESMTP id i35AuJfi007940 for ; Mon, 5 Apr 2004 03:56:19 -0700 (PDT) (envelope-from admin2@enabled.com) From: "Noah" To: freebsd-questions@freebsd.org Date: Mon, 5 Apr 2004 02:56:19 -0800 Message-Id: <20040405105527.M67974@enabled.com> In-Reply-To: <1081157355.93640.84.camel@enigma.8ball.co.za> References: <20040405081454.M1983@enabled.com> <1081157355.93640.84.camel@enigma.8ball.co.za> X-Mailer: Open WebMail 2.30 20040103 X-OriginatingIP: 64.121.33.4 (admin2) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 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 10:56:19 -0000 On Mon, 05 Apr 2004 11:29:15 +0200, Nelis Lamprecht wrote > On Mon, 2004-04-05 at 10:21, Noah wrote: > > > I was assuming with the > > multiuser functionality that users could only view databases for which they > > have granted access to. is there something else i need to configure here? > > Correct but you obviously have to setup each users permissions > correctly. Login as root and verify that your users do not have any > "Global Privileges" set and only privileges for the databases you > have specified. My guess is they all have at least the "Select" privilege. okay that was easy. yup the global privileges needed to Be unchecked for this user. okay I understand mysql lots more now. thanks, Noah > > Cheers, > -- > Nelis Lamprecht > PGP: http://www.8ball.co.za/pgpkey/nelis.asc > "Unix IS user friendly.. It's just selective about who its friends are."