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

Using phpMyAdmin version 3.4 and above you are able to change the default rows shown by:

On the phpMyAdmin home screen click Settings >> Main frame >> Browse mode and altering the value within Maximum number of rows to display.

Answer 2

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.

Answer 3

I have no access to config.inc.php

To show more records I add to my query:

LIMIT 0,1000;

to show 1,000 records, from 0 to 1000.

You can change 1000 to any number according to your needs.

One example:

SELECT id, folio, sucursal
FROM equipos
WHERE sucursal = 3
ORDER BY folio
LIMIT 0,1000;

Greetings from Mexico!

Answer 4

Already Checked..... Simple Steps Follow:-

1. Go PhpAdmin
2. Select Your Table
3. In Your table there is a field name Show, Which is actually a Button. Here two boxes present like(Start row(0) Number of Rows(1000) Header every(100)). ----
4. Press on Show button.

Answer 5

There is a config setting for this:

http://www.phpmyadmin.net/documentation/Documentation.html#cfg_MaxRows

Answer 6

If you don't have access to the installation files, you should use Ricks answer with "click Settings >> Main frame >> Browse mode and altering the value within Maximum number of rows to display", but it can be that this does not take effect for other users. If so, you can:

---

• login as root
• choose database phpmyadmin
• select table pma_userconfig
• search for the user in question (field username)
• edit the field config_data by adding e.g. "MaxRows":1000 to the contents in brackets, e.g. results in {"MaxRows":1000,"lang":"de"}

---

Hope that helps.

Answer 7

1. Find the file config.inc.php in your phpmyadmin directory

2. Edit it in any text editor

3. look for the line which contains the word $cfg['MaxRows']
4. if it has value like this ($cfg['MaxRows'] = 30; ) just edit the number (30) to the number of rows you like -- if that line doesn't exist just Add it at the end of the file before the ?> tag as follow:

......

$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman/5.1/en';
$cfg['MySQLManualType'] = 'searchable';

$cfg['MaxRows'] = 1000;

?>

Answer 8

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

Answer 9

just add the line : $cfg['MaxRows'] = 300; to /etc/phpmyadmin/config.inc.php (ubuntu)

Answer 10

The answers that refer to updating the MaxRows value in config.inc.php are correct, however, they fail to mention that this setting may be missing from config.inc.php.

The more complete procedure is as follows:

1. Find the file config.inc.php in your phpMyAdmin directory and open this in an editor
2. Look for the line that starts with $cfg['MaxRows']
3. If it is commented out, remove the '//' in front of the $cfg...

4. If the line is not present (it is missing in the default installation) then go to the bottom of the document and add the row

   $cfg['MaxRows'] = 50;

5. You can set the value for the 'MaxRows' attribute can be set to any one of the following: 25, 50, 100, 250, 500

6. Save the document and restart

Notice that there is a file called config.sample.inc.php in the phpMyAdmin directory. If you open this, you will see a list of possible settings (and some explanations) that you can add to your config.inc.php file to further configure phpMyAdmin.

I hope that this helps.