How can I remove the default phpmyadmin limit on MySQL queries? -

this question has answer here:

• phpmyadmin: change default number of rows displayed? 7 answers

phpmyadmin implements default limit 0, 30.
aware of show all button can use prefer option have code executed entered.

is there config option can set change or remove 30 limit @ session or system level?

here answer post:

in phpmyadmin directory, there file called "config.inc.php".

find line sets maxrows value:

$cfg['maxrows'] = 1000; 

and change value whatever want.