Archive for the tag 'information_schema'

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).