Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Hi everyone,

This may be seen as being off-topic, but I am not sure where I need to
look for the appropriate documentation/tutorial. All I would like to
know, if where (on a Linux system), I need to edit a file which will
stop my login timing out after 3600 seconds. I've tried Googling for
it for some time now (weeks, on and off), and I've tried the
phpmyadmin docs to no avail.

I refuse to believe for one minute that the answer to my question is
not in the phpmyadmin docs, but I'll be damned if I can find it... I
think I might be looking in the wrong place, as the docs I am looking
through look sparse.

I've tried searching through the phpmyadmin wiki for:

time out

Basically, anything I come across are problems people have reported,
or about the actual web interface to phpmyadmin, rather than the

If anyone can put me out of my misery, I would very much appreciate

Many, many thanks in advance.


Re: phpmyadmin


One thing you might check is the session timeout value. These settings
in a .htaccess would allow sessions to stay active for 24 hours or

php_value session.gc_maxlifetime  86400
php_value session.cookie_maxlifetime  86400

John Peters

Quoted text here. Click to load it

Re: phpmyadmin

Quoted text here. Click to load it

Wonderful. That's the last place I expected to look for these
settings... Thanks.

Re: phpmyadmin

At Mon, 07 May 2007 08:09:24 -0700, Daz let his monkeys type:

Quoted text here. Click to load it

Maybe a crude way, but have you tried grepping 3600 on all files in the
phpmyadmin dirs? Perhaps something pops up...  
Alternatively, have a look at the phpmyadmin database/tables itself (IIRC
it has one, right?)

Checked the online docs, nothing on timeout AFAICT indeed. Just browser
time-out with large table dumps/imports and such.


Re: phpmyadmin

Quoted text here. Click to load it

I had thought about it, but I am fairly new to Linux, and the
phpmyadmin files appear to be scattered in various places. Some of the
places to look for certain files are obvious, others don't seem to be
quite as obvious.

Quoted text here. Click to load it

Yes, you are correct, but I believe they are the settings for the
MySQL database, rather than anything to do with the inner-workings of
phpmyadmin. I seem to remember checking them a while back, but just to
be certain, I checked them again, and nothing.

Thanks for your input.

Re: phpmyadmin

Quoted text here. Click to load it

It's quite obvious really :-)

In the folder where phpMyAdmin lives (on your web server) there is a file  

In this file search for the line:
$cfg['LoginCookieValidity'] = 3600;

Change the value accordingly.


Re: phpmyadmin

Quoted text here. Click to load it

Strangely enough, I've search this file many times in the past, and
checked through all the options. Here are the contents of the file,
with the comments stripped out.

//$cfg['Servers'][$i]['host']          = 'localhost';
//$cfg['Servers'][$i]['port']          = '';
//$cfg['Servers'][$i]['socket']        = '';
//$cfg['Servers'][$i]['connect_type']  = 'socket';
//$cfg['Servers'][$i]['extension']     = 'mysql';
//$cfg['Servers'][$i]['compress']      = FALSE;
//$cfg['Servers'][$i]['controluser']   = '';
//$cfg['Servers'][$i]['controlpass']   = '';
//$cfg['Servers'][$i]['user']          = 'root';
//$cfg['Servers'][$i]['password']      = '';
//$cfg['Servers'][$i]['only_db']       = '';
//$cfg['Servers'][$i]['verbose']       = '';
//$cfg['Servers'][$i]['pmadb']         = 'phpmyadmin';
//$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
//$cfg['Servers'][$i]['relation']      = 'pma_relation';
//$cfg['Servers'][$i]['table_info']    = 'pma_table_info';
//$cfg['Servers'][$i]['table_coords']  = 'pma_table_coords';
//$cfg['Servers'][$i]['pdf_pages']     = 'pma_pdf_pages';
//$cfg['Servers'][$i]['column_info']   = 'pma_column_info';
//$cfg['Servers'][$i]['history']       = 'pma_history';
//$cfg['Servers'][$i]['verbose_check'] = TRUE;
//$cfg['Servers'][$i]['AllowRoot']     = TRUE;
//$cfg['Servers'][$i]['AllowDeny']['order'] = '';
//$cfg['Servers'][$i]['AllowDeny']['rules'] = array();

All of these lines are commented out as everything seems to work fine,
apart from the timeout aspect. I was pretty certain that the setting I
needed should go in there somewhere, I just couldn't find what the key
name for the array should be.

Many thanks for your input.

Site Timeline