Sunday, November 19, 2017

How to make permanents changes in phpMyAdmin configuration

I was very pissed off about my phpMyAdmin configuration.

Sometimes, some configuration can be useful, but, sometimes, the same option can be a hindrance. Group databases used to be very useful for me, but, suddenly, that option started to pissed me.


Theres another option with the same experience: By default, show only 50 elements by page:
Many times I need to go inside a table, and then, go to into another table in a faster way, but jumping between one, and another....that's very disagreeable!

And yes, there is a configuration panel with many options, even that what I need to solve the dilema...but there are temporaries, so, I need to solved that issue once and for all.

I realized that there's a "help item" next to the configuration name:


When I clicked that button, a page showed up: The page with the configuration variable that I need to change:
Then, I put that variable with a higher value inside the config.inc.php file:

And that's all. We need to save the file and recharge the page: