Monday, July 2, 2012

phpMyAdmin - To change the authentication timeout value and increase the default number of result in browse mode.

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 time limit value by editing your config file for phpMyAdmin. Simply open the config file (config.inc.php) and add or update the following config variable with increase/decrease 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. 

No comments:

Post a Comment