phpMyAdmin Tip - Display More Default Rows
Posted: Thu Oct 30, 2008 2:40 pm
For me, one of the annoying things with phpMyAdmin was the default to only display 30 rows at a time. In development, I always needed to display more rows. And to do that, you have to change the starting record and the number of rows.
Here is how to configure phpMyAdmin to display more rows:
In the phpMyAdmin directory, edit "config.inc.php"
To change from the default of 30 rows to 1000 rows, Add the following line:
After a few weeks with this change, it has been wonderful. 1000 seems to be a pretty good number for local work.
Here is how to configure phpMyAdmin to display more rows:
In the phpMyAdmin directory, edit "config.inc.php"
To change from the default of 30 rows to 1000 rows, Add the following line:
Code: Select all
$cfg['MaxRows'] = 1000;