blocks|key|1944504|text|config.inc.php+>+$cfg['LoginCookieValidity']+=+3600+*+9;+//+9+hours|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1944505|从ajreal：LoginCookieValidity发布的链接中编辑|1944506|对于第二个问题，在更改了php.ini中的php.ini之后，您是否重新启动了apache+(或者您使用的任何use服务器)？|1944507|entityMap|0|LINK|mutability|MUTABLE|url|http://wiki.phpmyadmin.net/pma/Config#LoginCookieValidity^0|H|1E|0|8|J|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@]|D|@$9|V|A|W|1|X]]|E|$]]|$1|H|3|I|5|6|7|Y|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

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

edit from the link posted by ajreal: <a href="http://wiki.phpmyadmin.net/pma/Config#LoginCookieValidity">LoginCookieValidity</a>

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

blocks|key|2301634|text|如何设置phpMyAdmin默认值1440秒超时更高：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2301635|定位php.ini
el@阿波罗:/var/lib/phpmyadmin$找到php.ini+/etc/php5+5/apache2/php.ini|ordered-list-item|2301636|以根用户身份打开文件以进行编辑，找到以下行：
session.gc_maxlifetime+=+1440|2301637|改为此(500000秒为5.7天)
session.gc_maxlifetime+=+500000|2301638|重启阿帕奇。|2301639|这样做会降低安全性，因为这样会增加跨站点脚本编写和中间攻击的机会。这是所有的乐趣和游戏，直到你发现你的服务器是一个僵尸网络农业的信用卡。|2301640|entityMap^0|0|R|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$]]|$1|I|3|J|5|H|7|W|8|@]|D|@]|E|$]]|$1|K|3|L|5|H|7|X|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|Y|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|Z|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|R|$]]

How to set phpMyAdmin default 1440 second timeout higher:

<ol>
<li>locate php.ini

<pre><code>el@apollo:/var/lib/phpmyadmin$ locate php.ini
/etc/php5/apache2/php.ini
</code></pre></li>
<li>open the file as root to edit, find this line:

<pre><code>session.gc_maxlifetime = 1440
</code></pre></li>
<li>Change it to this (500000 seconds is 5.7 days)

<pre><code>session.gc_maxlifetime = 500000
</code></pre></li>
<li>Restart apache. </li>
</ol>

Doing this decreases security because then it increases opportunity for cross site scripting and man in the middle attacks. It's all fun and games until you find your server is part of a botnet farming for credit cards.

blocks|key|747357|text|与其在session.gc_maxlifetime+php.ini文件中设置，不如将以下内容添加到您的文件中(通常在/etc/phpmyadmin目录中)：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|747358|ini_set('session.gc_maxlifetime',+'86400');|code-block|syntax|javascript|747359|这样，您就不会损害其他PHP脚本的安全性，也不会因为垃圾收集频繁而在RAM中造成过多的混乱。|747360|entityMap^0|3|M|12|14|0|0|0|1A|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

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):

<pre><code>ini_set('session.gc_maxlifetime', '86400');
</code></pre>

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

blocks|key|2301572|text|编辑phpMyAdmin的config.inc.php并添加或更新LoginCookieValidity的值如下：
$cfg‘’LoginCookieValidity‘=+3600+*+9；//+9小时|type|ordered-list-item|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2301573|上传超过200万：
cd+/etc/php5+5/apache2/+php.ini+sudo纳米php.ini|2301574|在upload_max_filesize中搜索php.ini，并将值更改为64M+(对于64+Mb)：
upload_max_filesize+=+64M|2301575|保存并退出。|2301576|重新启动apache：
sudo+/etc/init.d/apache2重新启动|2301577|完成！|2301578|unstyled|entityMap^0|D|E|X|J|0|0|1|J|N|7|11|3|0|0|4|6|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|15|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|N|3|O|5|6|7|19|8|@]|D|@]|E|$]]|$1|P|3|-4|5|Q|7|1A|8|@]|D|@]|E|$]]]|R|$]]

<ol>
<li>Edit phpMyAdmin's <code>config.inc.php</code> and add or update <code>LoginCookieValidity</code> the value as follows:

<pre><code>$cfg['LoginCookieValidity'] = 3600 * 9; // 9 hours
</code></pre></li>
<li>To upload more than 2M:

<pre><code>cd /etc/php5/apache2/php.ini

sudo nano php.ini
</code></pre></li>
<li>Search for <code>upload_max_filesize</code> in <code>php.ini</code>, and change value to <code>64M</code> (for 64 Mb):

<pre><code>upload_max_filesize = 64M
</code></pre></li>
<li>Save and exit.</li>
<li>Restart <code>apache</code>:

<pre><code>sudo /etc/init.d/apache2 restart
</code></pre></li>
<li>Finish!</li>
</ol>

blocks|key|1944791|text|对于第一个问题，您需要更改config.inc.php中的config.inc.php配置。在config.inc.php“根目录”中打开phpMyAdmin。查找包含以下内容的行：$cfg‘’LoginCookieValidity‘。将值设置为所需的秒数。如果该行不存在，只需按如下方式添加：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1944792|$cfg[‘LoginCookieValidity’]+=+3600;+//(3600+=+one+hour)|code-block|syntax|javascript|1944793|您将需要再次登录到phpmyadmin。|1944794|这还假设相应地设置了PHP会话垃圾收集。可以通过多种方式做到这一点：|1944795|php.ini；添加包含session.gc_maxlifetime+=+<seconds>的行(或更改现有行)|unordered-list-item|offset|length|style|CODE|1944796|appropriate；在适当的块中添加一行，显示php_admin_value+session.gc_maxlifetime+<seconds>。|1944797|config.inc.php+(phpMyAdmin)；在前面编辑的行后面添加一行ini_set(‘session.gc_maxlifetime’,+<seconds>);|1944798|关于第二个问题：|1944799|您需要同时更改upload_max_filesize和post_max_size在您的php.ini中。post_max_size值至少需要是upload_max_filesize值。|1944800|不要忘记重新启动服务器|1944801|参考文献|1944802|entityMap|0|LINK|mutability|MUTABLE|url|http://www.joho.se/2011/11/07/increasing-the-phpmyadmin-session-timeout/^0|0|0|0|0|C|Y|0|P|1C|0|15|19|0|0|7|J|R|D|1G|D|1Z|J|0|0|0|4|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1C|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1D|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1E|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1F|8|@$N|1G|O|1H|P|Q]]|9|@]|A|$]]|$1|R|3|S|5|M|7|1I|8|@$N|1J|O|1K|P|Q]]|9|@]|A|$]]|$1|T|3|U|5|M|7|1L|8|@$N|1M|O|1N|P|Q]]|9|@]|A|$]]|$1|V|3|W|5|6|7|1O|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1P|8|@$N|1Q|O|1R|P|Q]|$N|1S|O|1T|P|Q]|$N|1U|O|1V|P|Q]|$N|1W|O|1X|P|Q]]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|1Z|8|@]|9|@$N|20|O|21|1|22]]|A|$]]|$1|13|3|-4|5|6|7|23|8|@]|9|@]|A|$]]]|14|$15|$5|16|17|18|A|$19|1A]]]]

For the first question, you need to change the <code>$cfg[‘LoginCookieValidity’]</code> config in the config.inc.php.
Open config.inc.php in the phpMyAdmin “root” directory. Look for a line that contains this: $cfg[‘LoginCookieValidity’]. Set the value to the desired amount of seconds. If the line doesn't exist, just add it like this:

<pre><code>$cfg[‘LoginCookieValidity’] = 3600; //(3600 = one hour)
</code></pre>

You will need to login again to phpmyadmin.

This also assumes that the PHP session garbage collection is set-up accordingly. This can be done in a number of ways:

<ul>
<li>php.ini; add a line (or change an existing) that contains <code>session.gc_maxlifetime = &lt;seconds&gt;</code></li>
<li>Apache configuration; add a line to the appropriate block that says <code>php_admin_value session.gc_maxlifetime &lt;seconds&gt;</code></li>
<li>config.inc.php (phpMyAdmin); after the previously edited line, add a line with <code>ini_set(‘session.gc_maxlifetime’, &lt;seconds&gt;);</code></li>
</ul>

About the second question:

You need to change both, <code>upload_max_filesize</code> and <code>post_max_size</code> in your php.ini.
The <code>post_max_size</code> value needs to be at least the <code>upload_max_filesize</code> value.

Don't forget to restart your server

<a href="http://www.joho.se/2011/11/07/increasing-the-phpmyadmin-session-timeout/" rel="noreferrer">Reference</a>

blocks|key|747240|text|通过在post_max_size文件中更改/etc/php.ini来尝试。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|747241|entityMap^0|3|D|L|C|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

Try by changing <code>post_max_size</code> in <code>/etc/php.ini</code> file.

blocks|key|1944537|text|我在Poelinca的回答中补充说，这种限制的机制可以在libraries/Config.class.php下的PMA源中找到，|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1944538|function+checkUploadSize()|1944539|如果定义了upload_max_filesize或其他5米，则使用max_upload_size；如果也定义了max_upload_size，则将得到两者中的最小值。|1944540|(PMA版本3.3.7Deb+7)|1944541|entityMap^0|S|Q|0|0|Q|0|5|J|X|F|1J|F|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|C]|$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|10|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|M|$]]

I add to Poelinca's answer that the mechanism of this limit can be found in the PMA sources under <code>libraries/Config.class.php</code>, 

<code>function checkUploadSize()</code>

It will use <code>upload_max_filesize</code> if defined or 5M else and if <code>max_upload_size</code> is also defined it will get the min of the two. 

(PMA version 3.3.7deb7)

blocks|key|2301699|text|如果您希望避免phpMyAdmin经常超时，您可以添加以下一行：
$cfg‘’LoginCookieValidity‘=+86400；
默认情况下，phpMyAdmin每1440秒超时一次；要更改这一点，在php.ini中更改session.gc_maxlifetime如下：
session.gc_maxlifetime+=+86400|type|blockquote|depth|inlineStyleRanges|entityRanges|data|2301700|文件|unstyled|offset|length|2301701|entityMap|0|LINK|mutability|MUTABLE|url|https://wiki.phpmyadmin.net/pma/phpMyAdmin_configuration_file^0|0|0|2|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@$E|Q|F|R|1|S]]|A|$]]|$1|G|3|-4|5|D|7|T|8|@]|9|@]|A|$]]]|H|$I|$5|J|K|L|A|$M|N]]]]

<blockquote>
 If you wished to keep phpMyAdmin from timing out so often, you might
 add this line:
 
 $cfg['LoginCookieValidity'] = 86400;
 
 By default, phpMyAdmin times out every 1440 seconds; to change this,
 change the session.gc_maxlifetime in php.ini as follows:
 
 session.gc_maxlifetime = 86400
</blockquote>

<a href="https://wiki.phpmyadmin.net/pma/phpMyAdmin_configuration_file" rel="nofollow">https://wiki.phpmyadmin.net/pma/phpMyAdmin_configuration_file</a>

blocks|key|1944833|text|编辑phpMyAdmin的config.inc.php并添加或更新LoginCookieValidity的值如下：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1944834|$cfg['LoginCookieValidity']+=+3600+*+9;+//+9+hours|code-block|syntax|javascript|1944835|在wamp或xampp或您在php.ini使用的任何东西中，搜索upload_max_filesize，这是您应该更改的地方，|1944836|我们建议您不要使用超过6400万文件大小，因为有时它会导致崩溃：|1944837|upload_max_filesize+=+64M|1944838|保存并退出。|1944839|entityMap^0|D|E|X|J|0|0|E|7|W|J|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|15|8|@]|D|@]|E|$]]|$1|O|3|P|5|H|7|16|8|@]|D|@]|E|$I|J]]|$1|Q|3|R|5|6|7|17|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|T|$]]

Edit phpMyAdmin's <code>config.inc.php</code> and add or update <code>LoginCookieValidity</code> the value as follows:

<pre><code>$cfg['LoginCookieValidity'] = 3600 * 9; // 9 hours
</code></pre>

In wamp or xampp or anything you use at <code>php.ini</code>,
Search for <code>upload_max_filesize</code> this is where you should change it, 

we suggest you not use more than 64M filesize cause sometimes it makes crash:

<pre><code>upload_max_filesize = 64M
</code></pre>

Save and exit.

blocks|key|747382|text|我知道这篇文章已经被回答了，但我刚刚解决了同样的问题，所以我想我应该添加我的发现来帮助其他人。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|747383|我需要增加默认的PhpMyAdmin上传文件大小限制--2,048+but和我也更改了upload_max_filesize、post_max_size和memory_limit，但是没有什么改变。|747384|当我使用phpinfo()；脚本来确定PHP.ini文件在这里的位置时，我花了一段时间才发现这个问题:+C:\Program+(x86)\iis+express\PHP\v5.5\php.ini，但我最终在PhpMyAdmin主页中注意到，Web服务器正在运行版本:+5.6.31。因此，我更新了版本5.5和5.6的PHP.ini中的上传、发布和内存限制，并增加了PhpMyAdmin中的导入限制。|747385|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I'm aware this post has been answered, but I've just resolved the same issue, so I thought I would add my findings to help others.

I needed to increase the PhpMyAdmin upload file size limit from default the 2,048KiB and I too changed the upload_max_filesize and post_max_size and memory_limit, but nothing changed.

It took my a while to find the problem, when I used the phpinfo(); script to identify where the PHP.ini file was it said was here: C:\Program Files (x86)\iis express\PHP\v5.5\php.ini, but I finally noticed in the PhpMyAdmin homepage that the Web server was running version: 5.6.31. So, I updated the upload, post and memory limits in the PHP.ini for both versions 5.5 and 5.6 and the import limit in PhpMyAdmin increased.

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

phpMyAdmin configuration

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

如何增加phpmyadmin会话超时？如何增加phpmyadmin导入文件的大小限制(目前它说的是最大值:2,048 Max)。我试着在php.ini中更改php.ini，但没有产生任何不同。

问phpMyAdmin配置
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问phpMyAdmin配置EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问phpMyAdmin配置
EN