phpMyAdmin hiding the database setting the prefix invalidation problem

Source: Internet
Author: User
Tags phpmyadmin

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.