Extend phpMyAdmin time out

Monday, January 14, 2013 0 Comments

[How To]
Here you are :
  1. Go find phpmyadmin's config.inc.php
    Ubuntu version (from repo/ not lampp)
    $ sudo gedit /etc/phpmyadmin/config.inc.php
  2. Add these lines to the bottom of the file
    $cfg['LoginCookieValidity'] = 60*60*24;
    ini_set('session.gc_maxlifetime', $cfg['LoginCookieValidity']); 
  3. Restart apache
    $ sudo service apache2 restart
  4. Done and continue your work :D

Note : if with above trick, still doesn't work, try to edit /etc/phpmyadmin/config.inc.php file, then search for
$cfg['Servers'][$i]['auth_type'] = 'cookie';
 then edit / add the following
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'your_mysql_username';
$cfg['Servers'][$i]['password'] = 'your_mysql_password'; 

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Do you think I forgot to change this text? No, dude. I did it on purpose ahahahay..