phpmyadmin - users not seeing specific database
m.seaman at infracaninophile.co.uk
Mon Apr 5 02:05:39 PDT 2004
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?
Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks
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
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20040405/838433f6/attachment.bin
More information about the freebsd-questions