Thanks Jochen. It appears that this feature was added with ver 5. It does not matter in that what the user can see or do is limited by their rights. However we wanted very limited access for some one and it would be better to hide it. I found this can be done by adding the line $cfg['Servers'][$i] ['hide_db'] = 'information_schema'; in the phpMyAdmin|config.inc.php file
Tony On Oct 1, 7:36 pm, "Jochen Daum" <[EMAIL PROTECTED]> wrote: > Hi, > > Interesting question, I never wondered about it. It says > herehttp://dev.mysql.com/doc/refman/5.0/en/information-schema.html > > "Each MySQL user has the right to access these tables, but can see only the > rows in the tables that correspond to objects for which the user has the > proper access privileges. In some cases (for example, the > ROUTINE_DEFINITIONcolumn in the > INFORMATION_SCHEMA.ROUTINES table), users who have insufficient privileges > will see NULL" > > I think there is an option to restrict access to databases in phpmyadmin, > this could be used for what you want to achieve? > > Kind Regards, > > Jochen > > automatem . > software solutions EMAIL > WEB > PHONE > MOBILE [EMAIL PROTECTED] <[EMAIL PROTECTED]> > WWW.AUTOMATEM.CO.NZ <http://www.automatem.co.nz> > 0800 GO 4 AUTO (0800 464288) > 021 567 853 > > On Wed, Oct 1, 2008 at 6:31 PM, Tony Rigden <[EMAIL PROTECTED]>wrote: > > > > > Does anyone know why the information_schema database always shows in > > phpmyadmin regardless of who the user is or their priviliges. How do I > > hide it? Is issue with phpmyadmin or our mysql set up? > > Tony --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
