php WAMPServer phpMyadmin 超过360秒的最大执行时间

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/29916516/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-26 00:39:34  来源:igfitidea点击:

WAMPServer phpMyadmin Maximum execution time of 360 seconds exceeded

phpphpmyadminwampserver

提问by Kvasir

I just installed WampServer. It works when I visit my project page but when I try to navigate phpMyAdmin i get this error:

我刚刚安装了 WampServer。当我访问我的项目页面时它有效,但是当我尝试导航 phpMyAdmin 时出现此错误:

Maximum execution time of 360 seconds exceeded

超过 360 秒的最大执行时间

What is the problem?

问题是什么?

回答by RiggsFolly

A better solution here is to change the config that controls phpMyAdmin and not the php.inifile.

这里更好的解决方案是更改控制 phpMyAdmin 而不是php.ini文件的配置。

If you change the php.inifile you effect everything in PHP and should you write that infinite loop that we all do from time to time it will take longer to terminate your infinite loop than is sensible.

如果您更改php.ini文件,您会影响 PHP 中的所有内容,并且您是否应该编写我们不时执行的无限循环,终止无限循环所需的时间将比明智的要长。

Note:If you are using the 64bit WAMPServer the base folder name will be wamp64instead of wampso please amend the below folder names accordingly.

注意:如果您使用的是 64 位 WAMPServer,则基本文件夹名称将wamp64代替,wamp因此请相应地修改以下文件夹名称。

So change \wamp\alias\phpmyadmin.conf. By default it will look something like this although your version of phpMyAdmin will probably be different:

所以改变\wamp\alias\phpmyadmin.conf。默认情况下,它看起来像这样,尽管您的 phpMyAdmin 版本可能会有所不同:

Alias /phpmyadmin "c:/wamp/apps/phpmyadmin4.1.14/"

<Directory "c:/wamp/apps/phpmyadmin4.1.14/">
   Options Indexes FollowSymLinks MultiViews
   AllowOverride all
  <IfDefine APACHE24>
    Require local
  </IfDefine>
  <IfDefine !APACHE24>
    Order Deny,Allow
      Deny from all
      Allow from localhost ::1 127.0.0.1
    </IfDefine>
  php_admin_value upload_max_filesize 128M
  php_admin_value post_max_size 128M
  php_admin_value max_execution_time 360
  php_admin_value max_input_time 360
</Directory>

To extend the maximum time limit for importing a database, change the php_admin_value max_execution_timeparameter. You may also need to change the other parameters as larger databases tend to come in larger files and take longer to read as well. Example:

要延长导入数据库的最大时间限制,请更改该php_admin_value max_execution_time参数。您可能还需要更改其他参数,因为更大的数据库往往包含更大的文件,并且读取时间也更长。例子:

  php_admin_value upload_max_filesize 1024M
  php_admin_value post_max_size 1024M
  php_admin_value max_execution_time 1800
  php_admin_value max_input_time 1800

Don't forget to restart Apacheafter making changes to this file.

更改此文件后,不要忘记重新启动 Apache

回答by Gaurav Dave

In your php/php.ini change max_execution_time = 360to 99999.

在您的 php/php.ini 更改max_execution_time = 36099999.

OR

或者

You can add ini_set('max_execution_time', 600); //600 seconds = 10 minutesline on top of your php file.

您可以ini_set('max_execution_time', 600); //600 seconds = 10 minutes在 php 文件的顶部添加一行。

See, if that works.

看看,如果这有效。

回答by FosAvance

What helped me is to edit config.inc.phpin phpmyadminfolder and changed:

帮助我的是config.inc.phpphpmyadmin文件夹中编辑并更改:

$cfg['Servers'][$i]['host'] = 'localhost'; 

to

$cfg['Servers'][$i]['host'] = '127.0.0.1'; 

Basically change "localhost" to "127.0.0.1", xampp and wampp differently resolve those two.

基本上将“localhost”更改为“127.0.0.1”,xampp 和 wampp 以不同的方式解决这两个问题。