Home / server / Questions / 247061
Accepted
Eugene Yarmash
Asked: 2011-03-15 01:12:04 +0800 CST

Is there any way to disable grouping databases in phpMyAdmin?

  • 772

If you have db names like

test_db1
test_db2

phpmyadmin would create a group test. The group appears in the left side-bar with related databases displayed under it.

How can I disable this feature?

mysql phpmyadmin

3 Answers

  1. Best Answer

    I know this is something old -- so I'm posting here just in case someone stumbles in the same question.

    In the latest versions of phpMyAdmin the setting to flip is NavigationTreeEnableGrouping, i.e. in config.inc.php set:

    $cfg['NavigationTreeEnableGrouping'] = false;

    p.s. on localhost, config.inc.php is placed in /phpmyadminX.XX/ folder

    Or, for a "current session only", you can do it from phpmyadmin STARTPAGE: click settings -> navigation panel -> uncheck "group items in tree"

    • 31

  2. You can disable grouping by setting LeftFrameDBTree to false:

    $cfg['LeftFrameDBTree'] = false;

    UPDATE: the option was renamed to NavigationTreeEnableGrouping in phpMyAdmin 4.0.0.0 (2013-05-03).

    • 5

  3. (can't comment yet #*@%!)

    It seems relevant to precise that dependind on your linux distro, config file locations may vary.

    On my Debian (squeeze), /usr/share/phpmyadmin/config.inc.php contains a warning on the first lines, which I might well have missed :

    /**
 * Please, do not edit this file. The configuration file for Debian
 * is located in the /etc/phpmyadmin directory.
 */

    I have no idea whether this file may be replaced by some update or other mechanism, but it is usually a good practice to do things the way they are supposed to be.


    I also wanted to add that eugene y's answer saved me, but could have been more accurate :
    The exact parameter name, and what I have to set, on my probably old version of phpmyadmin, is 

    $cfg['LeftFrameDBTree'] = false;

    Btw, his link is kinda dead, which is the reason why answer are better copied here.


    And @adriano72, whose response is probably more up to date, I'd like to ask a precision about what are "the latest versions". As of which year ?
    I'm not even sure thoses version are more recent than the ones of eugene y's answer. I guess so, because of post dates, and could of course check, but my point is that those points should be clarified.

    If you think my comments are useful, please, upvote this, so that next time, I can comment where it belongs.

    • 0