Display all tables in the Phpmyadmin navigation column

Question

The Phpmyadmin ^(English) in these latest versions has the number of tables in the left side navigation limited, being applied a pagination to them.

Not only have I noticed being something slower as little practical in large databases.
^{(personal opinion)}

Question

How to disable paging in the left-hand column of Phpmyadmin so that all tables are present as in past versions ?

^{If relevant, the version in question is 4.2.3.}

Answer 1

Note: this solution does not effectively disable paging, but the result in practice is the same.

The answer depends on whether you want the settings to be applied always, or only in the current session.

To apply only in the current session:

1. Go to the main page of phpMyAdmin (house icon)
2. Under "Appearance Settings", click "More Settings..."
3. Click on "Navigation Panel"
4. Change the number of items in "Maximum items in branch" for a very high value
5. Click on "Save"

To always apply:

In this case you need to change the same parameter ("Maximum items in a branch"), but instead of setting it on the screen, edit the phpMyAdmin configuration file (config.inc.php), changing the default value of the parameter $cfg['MaxNavigationItems'].

More details can be found this phpMyAdmin documentation link.