Hi, Interesting question, I never wondered about it. It says here http://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] -~----------~----~----~----~------~----~------~--~---
