From owner-freebsd-questions@FreeBSD.ORG Mon Apr 5 02:32: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 5F4E616A4CE for ; Mon, 5 Apr 2004 02:32:42 -0700 (PDT) Received: from asarian-host.net (mail.asarian-host.net [194.109.160.70]) by mx1.FreeBSD.org (Postfix) with ESMTP id 69A4843D64 for ; Mon, 5 Apr 2004 02:32:41 -0700 (PDT) SRS0=xikWNeB+=HB=asarian-host.net=admin@asarian-host.net) Comments: To protect the identity of the sender, certain header fields are either not shown, or masked. Anonymous email accounts can be requested by filling in the appropriate form at: https://asarian-host.net/cgi-bin/signup.cgi Received: (from root@localhost) by mail.asarian-host.net (8.12.11/8.12.11) id i359WdXY006157 for freebsd-questions@freebsd.org; Mon, 5 Apr 2004 11:32:39 +0200 (CEST) (envelope-from admin@asarian-host.net) From: Mark Received-SPF: pass (asarian-host.net: domain of admin@asarian-host.net designates sender IP as SASL permitted sender) Message-Id: <200404050932.I359WCE7006136@asarian-host.net> Date: Mon, 05 Apr 2004 09:32:39 GMT X-Authenticated-Sender: admin@asarian-host.net X-Trace: KvOEfs7p0U0HMWYiMdvo3RlHyA1M5tAIkiwVACYBzfijpbs0cmLOoTUXNHQ8ZdVpw/m7pMyvhGE83mKb/4vcIg== X-Complaints-To: abuse@asarian-host.net X-Abuse-Info: Please be sure to forward a copy of ALL headers, otherwise we are unable to process your complaint Organization: Asarian-host To: "Noah" References: <20040405081454.M1983@enabled.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Auth: Asarian-host PGP signature iQEVAwUAQHEntzFqW1BleBN9AQGLVwf/YDkRlEoLuRbW0XPSYPHcWLggGnGqLwG9 gb2DuP6ta7192/pQF36GLw0x7qs4kEhVCZvmDL3XwEHRxVJ5yBmsZn7C84O0qc+7 ELtDcD/JViTmS/DxpamiPQr3Vix0fkb6yiRxmIFza1BtY3XvLjOYbTcwPrC0FE29 8Ac8ToJfUpP75XnO2m3tZnlimZqId09SKN/5W2mitOl5Dq/iv82DhnC0m2ahos/3 GK+MGHV95j6PgzupcAFR6XfucsSPNPqHKlO4Q9r9ONapNXossh1xXo2keDj+mluS o+UVyi52DXrEhzPwSCgqwvekX07pr5FfFhfYp9agVG0dTHL6GZibKA== =n/oU 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:32:42 -0000 Noah wrote: > FreeBSD 4.9-STABLE > phpmyadmin-2.5.6 > apache-1.3.29 > php_mod-4.3.5 > > I am getting a little better understanding of multiuser phpmyadmin. > but I must not be understanding it completely. I read through the > documentation and cannot find my particular issue discussed there. > > 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 they have granted access > to. is there something else i need to configure here? You forgot to mention the most important thing: your MySQL version. :) In the 3.x series, start MySQL with the "--safe-show-database" parameter. That will do what you want: only show databases the users have access to. In 4.0.18 (current production release), --safe-show-database is the default already. - Mark