phpmyadmin - users not seeing specific database

Noah admin2 at enabled.com
Mon Apr 5 03:56:19 PDT 2004


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."



More information about the freebsd-questions mailing list