Solve the problem that PHPMyAdmin keeps prompting "Loading" when editing database tables

Generally for the needs of ordinary VPS host users, we will be familiar with 1-2 one-click packages or WEB panel tools to deploy website environments, add sites and database deployment sites, and be diligent in backing up data regularly. Basically, it is still It can meet basic VPS hosting applications. In the morning, I encountered a netizen who mentioned that there was a loading problem with PHPMyAdmin during the website relocation process.

Because during the process of moving the website, I need to log in to the PHPMyAdmin page client and then edit and modify the website domain name bound to the original database of WORDPRESS (it should be the need to change the site domain name), but when I click to edit the database table, "Loading" appears. \\"question. This is the first time I have encountered this problem, because if I encounter slow access to PHPMyAdmin, it can be easily solved (two methods to solve the problem of slow opening and slow access to PHPMyAdmin).

Here Snail also searches the Internet to see if there are any solutions from other users:

First, modify the configuration file

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

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

# Search return strftime($date, $timestamp);

# Replace with the following code: if(extension_loaded(\\’gettext\\’))return strftime($date, $timestamp);

# China area is set like this. 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 Snail saw that this friend was using PHPMYADMIN4.4.15 version, and the corresponding files above were different, so there was still an error message after modification. 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.

In conclusion, 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.

Recommended site searches: agency registration, domain name purchase, German server, Chinese domain name, foreign server vps, server, registered domain name, cancellation registration, domain name price, Chinese domain name registration query,