How to list all tables in PhpMyAdmin's left menu?

Update:

Thanks to @Cloudkiller, there's another configuration setting that might need to be changed (as of 4.3.6) in addition to Update V4:

$cfg['FirstLevelNavigationItems']

Update V4:

According to Configuration Docs, you can modify:

$cfg['MaxNavigationItems']

The number of items that can be displayed on each page of the navigation tree.

Can also try:

$cfg['MaxTableList']

The maximum number of table names to be displayed in the main panel’s list (except on the Export page). This limit is also enforced in the navigation panel when in Light mode.


Here's how I did this (using v. 4.0.5 w/ "pmahomme" theme on my shared host):

  1. Go to the phpMyAdmin Home page (house icon).
  2. Under "Appearance Settings", go to "More Settings...".
  3. Select "Navigation Panel" in the second row from the top.
  4. Change the number in "Maximum items in branch".
  5. Click "Save"
  6. Bob's your uncle!

phpmyadmin settings screenshot


According to phpMyAdmin it is MaxNavigationItems:

$cfg['MaxNavigationItems']
Type: integer
Default value:  25

The number of items that can be displayed on each page of the navigation tree.