Hide information_schema in PhpMyAdmin

Published On: 2011-09-29

Category: Jargon Jabberwocky

There's this pesky database called information schema lying around. You can hide this database from PhpMyAdmin by modifying your config.inc.php (located in /etc/phpmyadmin on my system) to add the following:
$cfg['servers'][$i]['hide_db'] = 'information_schema';
You'll need to place the code inside the database loop, I put mine right above the $i++; at the end. The database is still access accessible by the user, it is just not visible to them anymore.