Sometime you might get crazy for the authentication timeout while working with phpMyAdmin. By default the timeout value is set to 1800 seconds which is 30 minutes.
You can easily increase this limit by editing your config file for phpMyAdmin. Simply open the config file (config.inc.php) and add following config variable with increased/decreased value.
$cfg['LoginCookieValidity'] = 36000; // In seconds
Another thing, I hate to browse the records of a table by clicking next -> next -> and next. So, I changed the default listing from 30 to 100.
Add following config variable and your preferred number of records in browse mode.
$cfg['MaxRows'] = 100;
That's all. Hope this helps.
Comments
Thanks a lot man. i wonder y they didnt leave it there as a configurable option to increase the timeout. this saves me 5 seconds ever 1400s :)
On Debian I also needed to change session.gc_maxlifetime in /etc/apache2/php.ini to the same value,
thanks!
I just want to let anyone falling on this post by Googling like I just did, and funny enough I commented 2 years back, that the file this setting resides in has changed to config.default.php found in the phpmyadmin/librairies directory.
Thank you very much :">
the quick timeout on my local dev box has been driving me crazy for a long time, but i've been too lazy to figure out how to change it. a quick google search lead me right here, and now i'm all set. the default limit of 30 rows in browsing tables was another one that i've been suffering with for awhile. thanks, thanks, thanks!
In ubuntu karmic koala the config.inc.php can be found inside the directly /etc/phpmyadmin/.
If you open the file using vim or any other editor you can't find a line containing the statement
$cfg['LoginCookieValidity']So what you have to do is, add the line under server settings and save the file.
Then next time you login, you can see the change get effected.
Just wanted to say thanks, been wanting to change the timeout and you made it easy. The max rows where bonus, though I often thought it would be nice to change that too so... Thanks!
Thanks a lot!
Also, at line 359 (phpMyAdmin version 3.1.1), edit getValue('LoginCookieValidity') > 1800, change the 1800 there too.
-neuroxik
hi frendz, Sqlyog the name sounds great as well the tool. I am best profiter from this db management tool. I tried with other tools but was not convinced as of this. So no second thought please try ....:)