Mysql: Change default number of rows displayed?

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?

 Answers

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.

---

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!

---

There is a config setting for this:

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

---

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

---

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;

?>