To modify how many tables appear:
- click on the home button to call up your phpMyAdmin main page
- click on the “settings” tab
- click on “Features”
- select the “Databases” tab
- in the “Maximum tables” row, modify it to however many you want.
Default value is 250, which is also the in-built default maximum value.
If you type a value higher than this (which you often want to do if you have a larger database), you’ll get the following message:
To increase this maximum value, you have to modify the configuration file for phpMyAdmin. This file is called config.inc.php, and it’s located on your server where your database is, at the root level of the folder that contains your database.
The code you have to write in this file is: $cfg['MaxTableList'] = 500; or however high you want to set it (1000, 5000…).
Note the semi-colon to close the statement.