16

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?

  • You don't like it? – Khaled Mar 14 '11 at 11:47
  • 2
    @Khaled: not really – Eugene Yarmash Mar 14 '11 at 12:45
25

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"

  • 1
    Worth noting, that this is system-wide setting (not per server), so you should set it as $cfg['NavigationTreeEnableGrouping'] in the end of configuration file. Not, as $cfg['Servers'][$i]['NavigationTreeEnableGrouping'] (in the beginning of config). – trejder May 18 '14 at 12:09
  • Saved my life with this. It was driving me insane. – GTCrais Apr 10 '18 at 13:05
3

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

0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.