phpMyAdmin configuration

Question

• How do I increase phpmyadmin session timeout?
• How do I increase phpmyadmin import file size limit(currently it says Max: 2,048KiB). I tried changing upload_max_filesize in php.ini but it didn't make any difference.

Answer 1

Edit phpMyAdmin's config.inc.php and add or update LoginCookieValidity the value as follows: $cfg['LoginCookieValidity'] = 3600 * 9; // 9 hours

in wamp or xamp or anything you use at php.ini Search for "upload_max_filesize" this is where you should change it, we suggest you not use more than 64M filesize cause sometimes it makes crash: upload_max_filesize = 64M Save and exit.

Answer 2

I add to Poelinca's answer that the mechanism of this limit can be found in the pma sources under libraries/Config.class.php , function checkUploadSize() : it will use upload_max_filesize if defined or 5M else, and if max_upload_size is also defined it will get the min of the two. (PMA version 3.3.7deb7)

Answer 3

config.inc.php > $cfg['LoginCookieValidity'] = 3600 * 9; // 9 hours

edit from the link posted by ajreal: LoginCookieValidity

for the second question , after changing upload_max_filesize in php.ini did you restart apache ( or whatever webserver you use ) ?

Answer 4

Rather than setting session.gc_maxlifetime in the php.ini file, better to add the following to your config.inc.php file (typically in the /etc/phpmyadmin directory):

ini_set('session.gc_maxlifetime', '86400');

That way you don't compromise security for other PHP scripts, or cause excessive clutter in the RAM due to infrequent Garbage Collection.