phpmyadmin logs out after 1440 secs

Question

In my local development Ubuntu box I use MySQL and phpmyadmin to work with the database    Whenever phpmyadmin is idle for 1440 secs  24min  the session expires  I lose my place and have to login and start over     I tried changing the  cfg  LoginCookieValidity     3600   9  inside config inc php but it still times out in 1440 seconds     I have restarted everything and cleared the browser cache  Firefox history -  Clear recent history -  Cache -  Everything    I m not sure why the increased timeout does not take effect   What am I doing wrong

User · Accepted Answer

I have found the solution and using it successfully for sometime now   Just install this Addon to your FF browser

User · Answer

Follow below steps to increase session timeout for phpmyadmin  Method 1   Login to phpMyAdmin with your root credentials Select Settings from the top in navigation bar Tap on Features Search for Login cookie validity field in General tab Change the value for this field to something greater than 1440 like 36000 or anything higher    Make sure whatever value you are entering in Login cookie validity is in seconds   Method 2  Locate your config inc php file For CentOS  Fedora servers   etc phpMyAdmin config inc php  For Ubuntu  Debian servers   etc phpmyadmin config inc php  Search LoginCookieValidity in config inc php and increase its value  cfg  Servers     i    LoginCookieValidity     1440     change to   cfg  Servers     i    LoginCookieValidity     36000   Save the changes to the config inc php file and restart your server   Increase session gc maxlifetime in php ini to be greater than or equal to the value that you entered in config inc php

User · Answer

Go to PHPMyAdmin in your browser      Settings   Features   Change the value of Login cookie validity   Save   NOTE  You will have to do this per session

User · Answer

Add this line to  config inc php    cfg  LoginCookieValidity     36000    In  setup lib index lib php   cf- gt getValue  LoginCookieValidity    gt  36000    If you don t already have a  htaccess file for your phpMyAdmin site  create one  and add the following line to override the default PHP session timeout   php value session gc maxlifetime 36000   I would not recommend altering this value in your main php ini file  as it will allow a ridiculously long session timeout for all your PHP sites   source  http   www sitekickr com blog increase-phpmyadmin-timeout

User · Answer

We can change the cookie time session feature at   Settings- Features- General- Login cookie validity  I found the answer in here    No activity within 1440 seconds  please log in again   EDIT   This solution will work only for the current session  to change permanently do   open config inc php in the root phpMyAdmin directory    wamp folder  wamp apps phpmyadmin version  config inc php   ubuntu   etc phpmyadmin  add this line   cfg  LoginCookieValidity      lt your timeout gt     Example   cfg  LoginCookieValidity      144000

User · Answer

change in php in file from wampicon php php  session gc maxlifetime   1440   to  session gc maxlifetime   43200

User · Answer

If you have phpmyadmin configuration storage setup  the settings will be pulled out of your phpmyadmin pma  userconfig table  and will override anything you have in config inc php  In this table  each MYSQL user can be assigned a different set of phpmyadmin settings

User · Answer

You will then get another warning     Your PHP parameter session gc maxlifetime is lower that cookie validity configured in phpMyAdmin  because of this  your login will expire sooner than configured in phpMyAdmin      That makes sense because php   s session will time out first anyways  So we will need to change  etc php ini    session gc maxlifetime   43200 That   s 12 hours in seconds     Restart your apache server and you are done   source  http   birdchan com home 2011 06 06 phpmyadmin-timeout-after-1440-seconds   this works for me

User · Answer

It is not working  The PHP session will expire anyway after 1440 seconds   Change in PHP ini this too   session gc maxlifetime   3600   http   www phpmyadmin net documentation Documentation html config  Also  from PHP ini   If you are using the subdirectory option for storing session files     see session save path above   then garbage collection does not    happen automatically  You will need to do your own garbage    collection through a shell script  cron entry  or some other method     For example  the following script would is the equivalent of    setting session gc maxlifetime to 1440  1440 seconds   24 minutes      cd  path to sessions  find -cmin  24   xargs rm

User · Answer

It worked for me after I    changed the  cfg  LoginCookieValidity   in   phpmyadmin folder  libraries config default php to 999999999  checked the php ini used by the phpmyadmin by php5 -i   grep php ini  went to the php ini file whose path I got from the grep command output and changed the session gc maxlifetime value to 999999999  restarted the server  In my case it was sudo service apache2 restart     Done  Logged in phpmyadmin and checked the cookie validity in Settings -  Features -  General -  Login cookie validity  It was 999999999  Also there was no warning  Your PHP parameter session gc maxlifetime is lower that cookie validity       The warning showed after I logged in phpmyadmin before I changed the php ini file   Check the version of php used by the phpmyadmin  You should change the ini file of the php that is used by the phpmyadmin  I have php5 and php i e 7  both installed  But my phpmyadmin uses php5  So I had to search for ini file of php5

User · Answer

After I tried all suggested methods here and still kept getting logged out  I turned to writing a small usercsript for Tampermonkey as I already have that extension  It is very simple and just sends a request to one of low footprint scripts of PHPMyAdmin once every minute  Here is the code        UserScript       name         PHPMyAdmin Keep Session Alive     namespace    https   www bitwizeor io      version      0 1     description  No more nasty PHPMyAdmin session expiries     match        http   localhost phpmyadmin         UserScript     function          use strict       console log  PHPMyAdmin Keep Session Alive activated        var url      window setInterval function            url       serverinfo a eq 1    prop  href            url      amp ajax request true amp ajax page request true             getJSON url           console log  pinging               60000

User · Answer

drive here your wamp installed then go to wamp then apps then your phpmyadmin version folder then go to libraries then edit config default php file  e g     E  wamp apps phpmyadmin4 6 4 libraries config default php   here you have to change       cfg  LoginCookieRecall     true    to      cfg  LoginCookieRecall     false    also you can change time of cookie instead to disable cookie recall       cfg  LoginCookieValidity     1440    to    cfg  LoginCookieValidity     anthing grater then 1440    mine is    cfg  LoginCookieValidity     199000    after changing restart your server   also there is another method but it reset when ever we restart our wamp server and here is that method also  login to your phpmyadmin dashbord then go to setting then click on features and in general tab you will see Login cookie validity put anything greater then 14400 but this is valid until next restart of your server

User · Answer

steps to change cookie expiration   step 1 Go to settings of Phpmyadmin  step 2 General  step 3 Login cookie validity  step 4 Update 1440 seconds default cookie expiration time with your new value

User · Answer

Steps for doing this using phpMyAdmin settings without any problem or requirements to change configs in php my ini or defining  htaccess file    Goto your phpMyAdmin install path  ex   usr share phpMyAdmin  on my centos7  and find create tables sql in one of its subfolders  phpMyAdmin sql create tables sql in my 4 4 9 version   and execute whole file contents on your current phpMyAdmin site from your web browser  This will create a database named phpmyadmin which can keep all your phpMyAdmin options saved permanently  In phpMyAdmin s config inc php  located on  etc phpMyAdmin  in my centos7 server  find the commented line  cfg  Servers    i   pmadb      phpmyadmin   and uncomment it  Now phpMyAdmin will use that custom database we generated in previous step   Goto phpMyAdmin from web browser and goto Server  gt  gt  Settings  gt  gt  Features  gt  gt   Login Cookie Validity  as in picture described by Pavnish and set the desired value  It works now    References   Niccolas Answer  PhpMyAdmin Configuration Storage  flashMarks Answer

User · Answer

To set permanently cookie you need to follow some steps  Goto-  etc phpmyadmin config inc php file  add this code    cfg  LoginCookieValidity      lt cookie expiration time in seconds  gt

User · Answer

If the parameter  cfg  LoginCookieValidity   is not taking effect in config inc php file   try disabling the session gc maxlifetime in the php ini file by putting a semicolon to the left like this     After this number of seconds  stored data will be seen as  garbage  and   cleaned up by the garbage collection process    http   php net session gc-maxlifetime   session gc maxlifetime   1440   Or try disabling both  cfg  LoginCookieValidity   and session gc maxlifetime   1440 by commenting both out   Then phpMyAdmin should no longer log out when you idle   It works for me on Windows   Don t forget to clear your browser cache and restart your webserver

User · Answer

1  Login to phpMyAdmin 2  From the home screen click on  More settings   middle bottom of screen for me  3  Click the  Features  tab button towards the top of the screen  4  For 20 days set the  Login cookie validity  setting to 1728000 5  Apply   php xampp

User · Answer

You can change the cookie time session feature at phpmyadmin web interface  Settings- gt Features- gt General- gt Login cookie validity   OR  If you want to change the  login cookie validity  in configuration file  then open the phpmMyAdmin configuration file  config inc php in the root directory of PHPMyAdmin  root directory is usually  etc phpmyadmin    After locating the config inc php   search for the line below and set it to the value of seconds you want phpmyadmin to timeout    cfg  LoginCookieValidity      or  Add the following    cfg    Servers     i      LoginCookieValidity       lt your new timeout gt     For example    cfg    Servers     i      LoginCookieValidity       lt 3600   3  gt     The Timeout is set to 3 Hours from the Example above   session gc maxlifetime might limit session validity and if the session is lost  the login cookie is also invalidated  So  we may need to set the session gc maxlifetime in php ini configuration file file location is   etc php5  apache2 php ini in ubuntu      session gc maxlifetime   3600   3    phpMyAdmin Documentation on LoginCookieValidity    cfg  LoginCookieValidity    Type    integer  number of seconds  Default value   1440  Define how long a login cookie is valid  Please note that php configuration option session gc maxlifetime might limit session validity and if the session is lost  the login cookie is also invalidated  So it is a good idea to set session gc maxlifetime at least to the same value of  cfg  LoginCookieValidity     NOTE    If your server crashed and cannot load your phpmyadmin page  check your apache log at  var log apache2 error log  If you got PHP Fatal error  Call to a member function get   on a non-object in  path to phpmyadmin libraries Header class php on line 135  then do a chmod 644 config inc php  that should take care of the error  You will then get another warning  Your PHP parameter session gc maxlifetime is lower that cookie validity configured in phpMyAdmin  because of this  your login will expire sooner than configured in phpMyAdmin   then change the session gc maxlifetime as mentioned above

User · Answer

I know this is an old post but I tried every solution I read  including those on this page to no avail  and then I got lucky so I m posting it here   I m running Ubuntu 17 10    I archived  etc phpmyadmin config inc php and replaced its content with the content of  usr share phpmyadmin config sample inc php   I then    1  Enabled  uncommented  all the options under  Storage database and tables     2  Included  ini set  session gc maxlifetime   86400    underneath the uncommented items  and   3  Provided a 32 character sequence for the  cfg  blowfish secret            YOU MUST FILL IN THIS FOR COOKIE AUTH      which is above the uncommented items    I saved the file and restarted phpMyAdmin    I selected Server  localhost -  Settings -  Features and changed the value of  Login cookie validity  to 86400  24 hours    Note any non default value you specify will cause the background color of this option to become yellow so don t be alarmed by it   The value should be less than or equal to the value you used in config inc php     I saved the settings  exited  and restarted phpMyAdmin   Finally  all of the messages disappeared  My session stays active as per the settings  all day in this case   and my settings are remembered   I surely hope this helps someone   It was frustrating for me to deal with and resolve

User · Answer

There seems to be UI for changing phpmyadmin configurations Start apache and click the following link  http   localhost phpmyadmin setup index php page form amp formset Features tab Security

User · Answer

For Ubuntu 18 04 I just edited the file  usr share phpmyadmin libraries config default php   Change   cfg  LoginCookieValidity     1440

User · Answer

You just Increase the phpMyAdmin Session Timeout  open config inc php in the root phpMyAdmin directory and add this line   from the wamp folder path wamp apps phpmyadmin4 0 4 config inc php   cfg  LoginCookieValidity      lt your timeout gt     Example   cfg  LoginCookieValidity      1440     Note  short cookie lifetime is all well and good for the development server not for your production server

User · Answer

method 1 with http login      php ini  session gc maxlifetime   86400   config inc php    cfg  Servers    i   auth type          http        method 2 with cookie login      php ini   session gc maxlifetime   86400   config inc php    cfg  Servers    i   auth type          cookie     cfg  Servers    i   LoginCookieValidity     86400    cfg  Servers    i   pmadb              phpmyadmin     cfg  Servers    i   controluser        phpmyadmin pma     cfg  Servers    i   controlpass        nigookike     cfg  Servers    i   userconfig      pma  userconfig      there s a lot of other table required for full functionality                                                                              all others can be left out unconfig except this one   mysql  -import phpMyAdmin sql create tables sql  -grant PRIVILEGES to phpmyadmin pma as below  db table  phpmyadmin  ALL PRIVILEGES   mysql db    SELECT  mysql host  SELECT  mysql tables priv   USAGE  mysql user  USAGE   -clear all entries should old one exists  phpmyadmin pma  userconfig   webUI   -clear broswer cookie  -as normal mysql user  access http   mysql phpmyadmin   at the bottom of page       The phpMyAdmin configuration storage is not completely configured  some extended features have been deactivated   Find out why    -near top of the page       Create missing phpMyAdmin configuration storage tables    -access http   mysql phpmyadmin  gt  settings  gt  features  gt  Login cookie validity  gt  86400  gt   apply   -check phpmyadmin pma  userconfig contain new entries of aforemention mysql user   N B    every user has independent setting and  webUI  procedure has to be repeated for each user if   The phpMyAdmin configuration storage is not completely configured  some extended features have been deactivated   Find out why      link does not appears on frontpage  go settings   features   warnings   Missing phpMyAdmin configuration storage tables    refresh  a few times will make it appears

User · Answer

You should restart apache or httpd  not mysqld  sudo service httpd restart   or   sudo  etc init d apache2 restart

[mysql] phpmyadmin logs out after 1440 secs

Examples related to mysql

Examples related to django

Examples related to phpmyadmin

Examples related to timeout

Examples related to logout