Friday, 16 August 2013

Extend phpMyAdmin time out

1)Go find phpmyadmin's
$ sudo gedit /etc/phpmyadmin/
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
If with above trick, still doesn't work, try to edit /etc/phpmyadmin/ 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';

10 Simple Ways To Improve SEO Rankings