Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
    
You don't like it? – Khaled Mar 14 '11 at 11:47
1  
@Khaled: not really – eugene y Mar 14 '11 at 12:45
up vote 13 down vote accepted

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"

share|improve this answer
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

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

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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