With phpMyAdmin default will be all the database is displayed, some such as Mysql,information_schema and so will show, so neither safe looking also uncomfortable, hide the best.
Modify Config.inc.php or config.sample.inc.php
The default should be no two configurations, which can be added manually:
ONLY_DB is only the name of the database displayed, in array format
HIDE_DB is the name of the database to be hidden, with regular matching pattern
According to your actual situation, two choose one of the settings is OK
$cfg[‘Servers‘][$i][‘only_db‘] = array(‘youqumob_union‘);$cfg[‘Servers‘][$i][‘hide_db‘] = ‘^(performance_schema|information_schema|phpmyadmin|mysql)‘;
Above these actually many people on the net have mentioned, I here mainly to explain the following question:
If your database is using an _ underscore to differentiate between prefix groupings, there may be a BUG where hiding will fail
Such as:
I have set up in the configuration only the Union can show, the others are hidden, but only the prefix of Count still shows, refused to obey the hidden command.
Tangled long time, finally found the reason, is because the default database name separator reason, replaced by other symbols on the line, but _ underline can not be grouped management, this is actually a very good function, the database more look dizzy, there is a group is much better, but because this BUG can not be used, No mind to change the source, will do it.
You can also add code to the configuration file:
// 设置数据库名分隔符,默认是 _ 下划线$cfg[‘NavigationTreeDbSeparator‘‘|‘;
Copyright NOTICE: This article for Bo Master original article, can be reproduced at will, but please specify the source: Http://blog.csdn.net/zhouzme
phpMyAdmin hiding the database setting the prefix invalidation problem