SBDavid
Dec 24th, 2010
Dec 24th, 2010
How can I hide information_schema database from phpMyAdmin?
How can I hide information_schema database from phpMyAdmin?
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.
To hide the information_schema database from phpMyAdmin on a particular MySQL logical server, add the following line to the phpMyAdmin config.inc.php file:
$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).
