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. 

 

Comment using an existing account (Google, Twitter, etc.)