I use phpmyadmin to create mysql database. And I have set the auth type to cookie in the config.inc.php. How do I change the time limit so that even if I logged in I stayed idle for hours it won't require me to log in again.
can you specify where can it be found?
2010-05-06 07:50:54
@user225269: You can find it in `php.ini` file or run the above statement in your script where you are setting session.
Sarfraz
2010-05-06 07:53:49
thanks...........
2010-05-06 08:35:38
@user225269: You are welcome :)
Sarfraz
2010-05-06 08:40:00
A:
I know this question is getting old, but the above 'selected' answer doesn't actually work. That just sets the time til session data gets removed.
After trying this and realizing it was failing, I spent some time reading through the phpmyadmin docs and found this:
$cfg['LoginCookieValidity'] = 86400;
$cfg['LoginCookieStore'] = 0;
The first line is the amount of time until you're auto-logged out. These values need to be set in your phpmyadmin install folder, within the file config.inc.php.
They were not there at all in my file but after adding them to the bottom it worked correctly. The first variable defines how long until you are logged out in seconds - I set mine to 1 day. The second variable is how long the cookie lasts. 0 means the cookie lasts til you close your browser.
Setting up these two variables will have the desired effect. You could set both to some insane number and never log in, but that would be pretty insecure.
Erik
2010-05-19 06:14:38