What should I do if the 'Loading' error message appears when editing the database in PHPMyAdmin?

PHPMyAdmin editing database shows "Loading" error solution: 1. Find the [libraries/Util.class.php] file, replace the relevant code and save it; 2. Close the firewall tool and wait until the operation is completed. Just turn it on.

Solution to the "Loading" error when editing the database in PHPMyAdmin:

First, modify Configuration file

This method comes from the Internet. According to the instructions, it can be used for phpmyadmin 4.0.2 php 5.5.0 version.

1. Go to the PHPMYADMIN file directory to find the libraries/Util.class.php file, find

#, search for

return strftime($date, $timestamp);

# and replace it with The following code:

if(extension_loaded('gettext'))
return strftime($date, $timestamp);

# This is the setting for China.

date_default_timezone_set('UTC');
return gmdate('Y-m-d H:i:s', $timestamp + 28800);

2. Save the file and replace it. It can be solved according to the prompts.

Second, modify the firewall settings

Here Lao Zuo saw that this friend is using PHPMYADMIN4.4.15 version, and the corresponding files above are different. So after the modification, there is still an error message. When I was about to give up, I accidentally asked this friend if the firewall software tool was useful in the VPS, and he told me that it was. The problem may lie here. Maybe the firewall directly determines that the operating database may be a SQL injection problem, so it blocks the current IP.

Solution: We can either turn off the firewall tool and turn it on again after the operation is completed, or add the local IP address when we operate the database to the whitelist, so there will be no problem.

Summary, so far, the "loading" problem in PHPMyadmin database management can be solved. If other friends have not solved it or have other methods, they can share it.

Related tutorial recommendations: phpmyadmin

The above is the detailed content of What should I do if the 'Loading' error message appears when editing the database in PHPMyAdmin?. For more information, please follow other related articles on the PHP Chinese website!