Generally for the common VPS Host user needs, we will be familiar with the 1-2 kinds of one-key package or Web Panel tool deployment site environment, will add site and database deployment site, as well as diligent a little regular backup data, basically still can meet the basic VPS host applications. Morning when there is a netizen proposed to move in the site during the phpMyAdmin loading problem.
Because of its moving site in the process, you need to login to phpMyAdmin page client and then edit the original database bound WordPress site domain name (should be replacement site domain name needs), but click Edit Database table when the "loading" problem. This problem is the first time left or encountered, because if encountered phpMyAdmin access speed is OK to resolve (solve phpMyAdmin open and access slow 2 ways).
Here old left also search the Internet to see if there are any other solutions for users:
First, modify the configuration file
This method comes from the network, as indicated by the phpMyAdmin 4.0.2 PHP 5.5.0 version is available.
1, to the phpMyAdmin file directory to find libraries/util.class.php files, find
| The code is as follows |
Copy Code |
# find
Return strftime ($date, $timestamp);
# Replace with the following code:
if (extension_loaded (' GetText '))
Return strftime ($date, $timestamp);
# China area is set up like this.
Date_default_timezone_set (' UTC ');
Return Gmdate (' y-m-d h:i:s ', $timestamp + 28800);
|
2, save the file replacement, according to the hint can be solved.
Second, modify the firewall settings
Here the old left to see this friend is using the PHPMYADMIN4.4.15 version, and the corresponding file is not the same, so after the modification still has the wrong hint. is ready to give up when accidentally asked a friend of the VPS is useful to firewall software tools, its informed is useful to. Should be the problem here, the firewall may directly determine the operation of the database may be considered to be an SQL injection problem, so to mask the current IP.
Workaround: We can either shut down the firewall tool, wait until the operation is finished, or add a white list to our local IP address when we operate the database, so there is no problem.
To summarize, the problem of "loading" the phpMyAdmin database management has so far been solved, if there are other friends that are not resolved or there are other ways to share them.
