phpmyadmin - users not seeing specific database

[Matthew Seaman]

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

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

-- 
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20040405/838433f6/attachment.bin