Date: Mon, 05 Apr 2004 09:32:39 GMT From: Mark <admin@asarian-host.net> To: "Noah" <admin2@enabled.com> Cc: freebsd-questions@freebsd.org Subject: Re: phpmyadmin - users not seeing specific database Message-ID: <200404050932.I359WCE7006136@asarian-host.net> References: <20040405081454.M1983@enabled.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200404050932.I359WCE7006136>