phpMyAdmin: change default number of rows displayed?

user_4376 0
Viewed 43978

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?

phpmyadmin mysql php
10 Answers

  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:

As shown in the picture

......

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

$cfg['MaxRows'] = 1000;

?>
user_48878480

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

user_26641080

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.

user_21705740
Related