Article ID: 9479, created on Dec 22, 2010, last review on May 11, 2014

  • Applies to:
  • H-Sphere 3.4
  • H-Sphere 3.5 SPU

Symptoms

By default, phpMyAdmin shows all databases available to a user. So, in addition to the databases that belong to the user, the information_schema database is also visible to them. This confuses some users.

Resolution

To hide the information_schema database from phpMyAdmin on a particular MySQL logical server, add the following line to /hsphere/shared/apache/htdocs/phpMyAdmin/config.inc.php:

$cfg['Servers'][$i]['hide_db'] = 'information_schema';

Please note that this affects only phpMyAdmin, and users will still be able to use the information_schema database from other applications (for example, from the mysql command-line client).

f213b9fa8759d57bee5d547445806fe7 f90e90e234d2835301363089f6b828e5 6311ae17c1ee52b36e68aaf4ad066387 7f922a4e770ce85df792db1005dd3733 2e39a5e5b1423cc126cf735bac076008 f51a27b0a406fdfb3fcda8033c7f914d

Email subscription for changes to this article
Save as PDF