Removing or extending the phpMyAdmin timeout period

steva
steva used Ask the Experts™
on
After opening a table with phpMyAdmin and working with it a while, the connection is dropped automatically after something like 5 minutes of inactivity.  Then I have shut down phpMYAdmin , reopen it, and go open my  table again, which is a real nuisance. No one else has access to this computer so I would prefer to leave the connection open until I shut down phpMyAdmin, or at least leave it open for 30 minutes or so.  Is there any way to do that?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
In config.inc.php, set $cfg['LoginCookieValidity'] = 1800.

That will set the timeout to 30 minutes.

HTH,
Dan
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
Standard PHP timeout is 1440 second (24 minutes) of inactivity.  That timeout gets reset any time you click on anything that accesses the server or reloads the page.  You have to have changed something to get it to be only 5 minutes.

Author

Commented:
Dan, could you tell me where config.inc.php is?

Thanks

Commented:
Windows or Linux?

On Windows, just click Start and type the filename. You should get the location. Or install Search Everywhere.

On Linux, type this while root:
find / -name config.inc.php
Dave BaldwinFixer of Problems
Most Valuable Expert 2014
Commented:
'config.inc.php' is going to be in the main phpMyAdmin directory.  At least it is on all my systems.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial