Setting phpMyAdmin to show more rows by default
Here is a quick tip for setting phpMyAdmin to show more rows by default.
Find your config.inc.php file, which if you are running on XAMPP would be in your xampp/phpmyadmin folder or if you are on linux then probably /usr/share/phpmyadmin or the directory you chose to put it in.
Open config.inc.php and add a line near the bottom but before the php closing tag ?> that has the following: $cfg['MaxRows'] = 500;
You can make the row number what you like, 500 usually does it for me though. Afterwards, you will need to clear your browser's cache/delete your cookies. Hooray, now we can get all those rows on one page.