I have a LAMP server running on my local machine. The version I use is Bitnami.
I use this server quite extensively for testing code, site layout and various tests, and therefore use PhpMyAdmin a lot. There are two things that bug me constantly though – the first is the limit on file size to import data and the other is the timeout. While the need for these on a live production platform is obvious, they are just an irritation on a local device.
To change the timeout, open the file apps/phpmyadmin/htdocs/config.inc.php The location may depend on your variant of LAMP but a quick search should find it.
Change the setting $cfg[‘LoginCookieValidityDisableWarning’] to ‘true’.
Next find the line containing $cfg[‘LoginCookieValidity’] and change the value to the required timeout.
To change the maximum upload filesize, open the file apps/phpmyadmin/conf/httpd-app.conf Again, your location of this file may be different.
Change php_value upload_max_filesize and php_value post_max_size to the required value