blocks|key|206135|text|我已经找到了解决方案，并成功地使用了一段时间。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|206136|只需将此Addon安装到您的FF浏览器即可。|offset|length|206137|entityMap|0|LINK|mutability|MUTABLE|url|https://addons.mozilla.org/en-US/firefox/addon/phpmyadmin-timeout-preventer/^0|0|4|5|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I have found the solution and using it successfully for sometime now.

Just install this <a href="https://addons.mozilla.org/en-US/firefox/addon/phpmyadmin-timeout-preventer/" rel="nofollow">Addon</a> to your FF browser.

blocks|key|205948|text|将下面这一行添加到/config.inc.php：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|205949|$cfg['LoginCookieValidity']+=+36000;|code-block|syntax|javascript|205950|在/setup/lib/index.lib.php中|205951|$cf->getValue('LoginCookieValidity')+>+36000;|205952|如果您的phpMyAdmin站点还没有.htaccess文件，请创建一个，然后添加以下行来覆盖默认的phpMyAdmin会话超时：|205953|php_value+session.gc_maxlifetime+36000|205954|我不建议在您的主php.ini文件中更改此值，因为它将允许所有PHP站点的会话超时时间过长。|205955|来源：http://www.sitekickr.com/blog/increase-phpmyadmin-timeout/|offset|length|205956|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sitekickr.com/blog/increase-phpmyadmin-timeout/^0|0|0|0|0|0|0|0|3|1M|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|16|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|19|8|@]|9|@$S|1A|T|1B|1|1C]]|A|$]]|$1|U|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]]]

Add this line to /config.inc.php:

<pre><code>$cfg['LoginCookieValidity'] = 36000;
</code></pre>

In /setup/lib/index.lib.php

<pre><code>$cf-&gt;getValue('LoginCookieValidity') &gt; 36000;
</code></pre>

If you don't already have a .htaccess file for your phpMyAdmin site, create one, and add the following line to override the default PHP session timeout:

<pre><code>php_value session.gc_maxlifetime 36000
</code></pre>

I would not recommend altering this value in your main php.ini file, as it will allow a ridiculously long session timeout for all your PHP sites.

source: <a href="http://www.sitekickr.com/blog/increase-phpmyadmin-timeout/">http://www.sitekickr.com/blog/increase-phpmyadmin-timeout/</a>

blocks|key|205904|text|似乎有用于更改phpmyadmin配置的UI启动apache并单击以下链接|type|unstyled|depth|inlineStyleRanges|entityRanges|data|205905|http://localhost/phpmyadmin/setup/index.php?page=form&formset=Features#tab_Security|offset|length|style|CODE|205906|entityMap^0|0|0|2B|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

There seems to be UI for changing phpmyadmin configurations
Start apache and click the following link

<code>http://localhost/phpmyadmin/setup/index.php?page=form&amp;formset=Features#tab_Security</code>

blocks|key|205850|text|您应该重新启动apache或httpd，而不是mysqld|type|unstyled|depth|inlineStyleRanges|entityRanges|data|205851|sudo+service+httpd+restart|code-block|syntax|javascript|205852|或|205853|sudo+/etc/init.d/apache2+restart|205854|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You should restart apache or httpd, not mysqld

<pre><code>sudo service httpd restart
</code></pre>

or 

<pre><code>sudo /etc/init.d/apache2 restart
</code></pre>

blocks|key|206226|text|1)登录到phpMyAdmin+2)在主屏幕上单击“更多设置”(我在屏幕的中下部)+3)单击屏幕顶部的“功能”选项卡/按钮。4)在20天内，将“登录cookie有效性”设置为1728000。5)应用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|206227|php+xampp|206228|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

1) Login to phpMyAdmin
2) From the home screen click on "More settings" (middle bottom of screen for me)
3) Click the "Features" tab/button towards the top of the screen.
4) For 20 days set the "Login cookie validity" setting to 1728000
5) Apply.

<h1>php xampp</h1>

blocks|key|206190|text|要永久设置cookie，您需要执行以下步骤|type|unstyled|depth|inlineStyleRanges|entityRanges|data|206191|转到->/etc/phpmyadmin/config.inc.php文件|offset|length|style|CODE|206192|添加此代码|206193|$cfg['LoginCookieValidity']+=+<cookie+expiration+time+in+seconds+>+|code-block|syntax|javascript|206194|entityMap^0|0|4|U|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|V|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

To set permanently cookie you need to follow some steps

Goto-><code>/etc/phpmyadmin/config.inc.php</code> file

add this code 

<pre><code>$cfg['LoginCookieValidity'] = &lt;cookie expiration time in seconds &gt; 
</code></pre>

blocks|key|206106|text|从wampicon/php/php更改php.in文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|206107|session.gc_maxlifetime+=+1440|code-block|syntax|javascript|206108|至|206109|session.gc_maxlifetime+=+43200|206110|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

change in php.in file from wampicon/php/php

<pre><code>session.gc_maxlifetime = 1440
</code></pre>

to

<pre><code>session.gc_maxlifetime = 43200
</code></pre>

blocks|key|206006|text|如果参数$cfg['LoginCookieValidity']在config.inc.php文件中不生效，请尝试在php.ini文件中禁用session.gc_maxlifetime，方法是在左侧放置一个分号，如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|206007|;+After+this+number+of+seconds,+stored+data+will+be+seen+as+'garbage'+and
;+cleaned+up+by+the+garbage+collection+process.
;+http://php.net/session.gc-maxlifetime
;+session.gc_maxlifetime+=+1440|code-block|syntax|javascript|206008|或者尝试通过注释掉$cfg['LoginCookieValidity']和session.gc_maxlifetime+=+1440来禁用它们。|206009|然后，当您空闲时，phpMyAdmin将不再注销。它适用于我的视窗系统。不要忘了清除你的浏览器缓存并重新启动你的and服务器。|206010|entityMap^0|4|R|W|E|1X|M|0|0|9|R|11|T|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|13|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|P|$]]

If the parameter <code>$cfg['LoginCookieValidity']</code> is not taking effect in <code>config.inc.php</code> file, 
try disabling the <code>session.gc_maxlifetime</code> in the php.ini file by putting a semicolon to the left like this:

<pre><code>; After this number of seconds, stored data will be seen as 'garbage' and
; cleaned up by the garbage collection process.
; http://php.net/session.gc-maxlifetime
; session.gc_maxlifetime = 1440
</code></pre>

Or try disabling both <code>$cfg['LoginCookieValidity']</code> and <code>session.gc_maxlifetime = 1440</code> by commenting both out.

Then phpMyAdmin should no longer log out when you idle. It works for me on Windows. Don't forget to clear your browser cache and restart your webserver.

blocks|key|424339|text|更改cookie过期的步骤|type|unstyled|depth|inlineStyleRanges|entityRanges|data|424340|步骤1:转到Phpmyadmin的设置|424341|第2步:常规|424342|第3步:登录cookie有效性|424343|步骤4:用您的新值更新1440秒的默认cookie过期时间|424344|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

steps to change cookie expiration 

step 1:Go to settings of Phpmyadmin

step 2:General

step 3:Login cookie validity

step 4:Update 1440 seconds default cookie expiration time with your new value

blocks|key|206029|text|如果您有phpmyadmin+configuration+storage设置，这些设置将从您的phpmyadmin.pma__userconfig表中拉出，并将覆盖您在config.inc.php中的任何设置。在此表中，可以为每个MYSQL用户分配一组不同的phpmyadmin设置。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|206030|entityMap|0|LINK|mutability|MUTABLE|url|http://wiki.phpmyadmin.net/pma/Configuration_storage^0|4|W|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If you have <a href="http://wiki.phpmyadmin.net/pma/Configuration_storage" rel="nofollow">phpmyadmin configuration storage</a> setup, the settings will be pulled out of your phpmyadmin.pma__userconfig table, and will override anything you have in config.inc.php. In this table, each MYSQL user can be assigned a different set of phpmyadmin settings.

blocks|key|206259|text|在我尝试了这里所有建议的方法，并且仍然保持注销后，我转向为turned猴子写了一个小的usercsript，因为我已经有了那个扩展。它非常简单，每分钟只向PHPMyAdmin的一个占用空间较小的脚本发送一个请求。代码如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|206260|//+==UserScript==
//+@name+++++++++PHPMyAdmin+Keep+Session+Alive
//+@namespace++++https://www.bitwizeor.io/
//+@version++++++0.1
//+@description++No+more+nasty+PHPMyAdmin+session+expiries
//+@match++++++++http://localhost/phpmyadmin/*
//+==/UserScript==

(function()+{
++++'use+strict';
++++console.log('PHPMyAdmin+Keep+Session+Alive+activated');
++++var+url;
++++window.setInterval(function(){
++++++++url+=+$("#serverinfo+a:eq(1)").prop("href");
++++++++url+%2B=+'&ajax_request=true&ajax_page_request=true';
++++++++$.getJSON(url);
++++++++console.log('pinging+...');
++++},+60000);
})();|code-block|syntax|javascript|206261|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

After I tried all suggested methods here and still kept getting logged out, I turned to writing a small usercsript for Tampermonkey as I already have that extension. It is very simple and just sends a request to one of low footprint scripts of PHPMyAdmin once every minute. Here is the code:

<pre><code>// ==UserScript==
// @name PHPMyAdmin Keep Session Alive
// @namespace https://www.bitwizeor.io/
// @version 0.1
// @description No more nasty PHPMyAdmin session expiries
// @match http://localhost/phpmyadmin/*
// ==/UserScript==

(function() {
 'use strict';
 console.log('PHPMyAdmin Keep Session Alive activated');
 var url;
 window.setInterval(function(){
 url = $("#serverinfo a:eq(1)").prop("href");
 url += '&amp;ajax_request=true&amp;ajax_page_request=true';
 $.getJSON(url);
 console.log('pinging ...');
 }, 60000);
})();
</code></pre>

blocks|key|424514|text|我知道这是一个古老的帖子，但我尝试了我读到的每一个解决方案，包括这个页面上的那些都没有用，然后我很幸运，所以我把它贴在了这里。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|424515|我运行的是Ubuntu+17.10。|424516|我归档了/etc/phpmyadmin/config.inc.php，并将其内容替换为/usr/share/phpmyadmin/config.sample.inc.php的内容。|424517|然后我|424518|+1)+Enabled+(uncommented)+all+the+options+under+"Storage+database+and+tables";+
+2)+Included+"ini_set('session.gc_maxlifetime',+86400);"+underneath+the+uncommented+items;+and+
+3)+Provided+a+32+character+sequence+for+the+$cfg['blowfish_secret']+=+'';+/*+YOU+MUST+FILL+IN+THIS+FOR+COOKIE+AUTH!+*/,+which+is+above+the+uncommented+items.|code-block|syntax|javascript|424519|我保存了文件并重新启动了phpMyAdmin。|424520|我选择了服务器:本地主机->设置->功能，并将“登录cookie有效性”的值更改为86400+(24小时)。注您指定的任何非默认值都会导致此选项的背景颜色变为黄色，因此不要对此感到惊慌。该值应小于或等于您在config.inc.php中使用的值。|424521|我保存了设置，退出并重新启动了phpMyAdmin。|424522|最后，所有的消息都消失了。根据设置，我的会话保持活动状态(在本例中为全天)，并且我的设置会被记住。|424523|我当然希望这对某些人有帮助。对我来说，处理和解决问题是令人沮丧的。|424524|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|12|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|17|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

I know this is an old post but I tried every solution I read, including those on this page to no avail, and then I got lucky so I'm posting it here.

I'm running Ubuntu 17.10. 

I archived /etc/phpmyadmin/config.inc.php and replaced its content with the content of /usr/share/phpmyadmin/config.sample.inc.php.

I then 

<pre><code> 1) Enabled (uncommented) all the options under "Storage database and tables"; 
 2) Included "ini_set('session.gc_maxlifetime', 86400);" underneath the uncommented items; and 
 3) Provided a 32 character sequence for the $cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */, which is above the uncommented items.
</code></pre>

I saved the file and restarted phpMyAdmin. 

I selected Server: localhost -> Settings -> Features and changed the value of "Login cookie validity" to 86400 (24 hours). Note any non default value you specify will cause the background color of this option to become yellow so don't be alarmed by it. The value should be less than or equal to the value you used in config.inc.php. 

I saved the settings, exited, and restarted phpMyAdmin.

Finally, all of the messages disappeared. My session stays active as per the settings (all day in this case), and my settings are remembered.

I surely hope this helps someone. It was frustrating for me to deal with and resolve.

blocks|key|424569|text|对于Ubuntu18.04，我只是编辑了文件/usr/share/phpmyadmin/libraries/config.default.php|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|424570|更改：$cfg['LoginCookieValidity']+=+1440|424571|entityMap^0|M|1E|0|3|Y|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

For Ubuntu 18.04 I just edited the file <code>/usr/share/phpmyadmin/libraries/config.default.php</code> 

Change:
<code>$cfg['LoginCookieValidity'] = 1440</code>

In my local development Ubuntu box I use MySQL and phpmyadmin to work with the database. 

Whenever phpmyadmin is idle for 1440 secs (24min) the session expires. I lose my place and have to login and start over. 

I tried changing the <code>$cfg['LoginCookieValidity'] = 3600 * 9;</code> inside <code>config.inc.php</code> but it still times out in 1440 seconds. 

I have restarted everything and cleared the browser cache (Firefox history -> Clear recent history -> Cache -> Everything).

I'm not sure why the increased timeout does not take effect. What am I doing wrong?

phpmyadmin logs out after 1440 secs

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

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

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

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

社区新版编辑器体验调研

在我本地开发的Ubuntu box中，我使用MySQL和phpmyadmin来处理数据库。只要phpmyadmin空闲1440秒(24分钟)，会话就会过期。我失去了我的位置，不得不登录并重新开始。我尝试在config.inc.php中更改$cfg['LoginCookieValidity'] = 3600 * 9;，但它仍然在1440秒内超时。我已经重启了所有内容并清除了浏览器缓存(火狐历史缓存、

问phpmyadmin在1440秒后注销
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问phpmyadmin在1440秒后注销EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问phpmyadmin在1440秒后注销
EN