phpMyAdmin: change default number of rows displayed?

Question

By default, phpMyAdmin shows me 30 rows whenever I load a table (the query contains "LIMIT 30"). I generally want to see (up to) a few hundred rows.

Is there a way to change that default setting?

Answer 1

phpMyAdmin has a config file called config.inc.php. You should be able to find appropriate setting in there.

Answer 2

There is a config setting for this:

http://www.phpmyadmin.net/documentation/Documentation.html#cfg%5FMaxRows

Answer 3

In your phpMyAdmin directory, there will be a file called "config.inc.php".

Find the line where it sets the MaxRows value:

$cfg['MaxRows'] = 1000;

And change the value to whatever you want.