2 ways to solve the problem of slow opening and access of PHPMyAdmin

This problem has been encountered many times before. Because it is rarely used, and when it is really needed, it can be used directly by turning it out, so this problem has not been solved. This problem has been raised by netizens again. For example, when using LNMP and the environment package built by yourself, it is very slow to log in to the homepage when accessing PHPMyAdmin to manage the MYSQL database. This problem needs to be solved.

When such a problem occurs, there must be two problems. One is that there is a delay in calling the external file, and the other is that an external file is blocked. Here are two methods. I hope you can choose one method to solve it quickly. The problem of slow access to PHPMyAdmin.

First, block automatic update detection

By default, PHPMyAdmin online upgrade files may cause blocking, so we directly prevent upgrade detection. Find the version_check.php file, and then find the following files.

$save = true;$file = \\'http://www.phpmyadmin.net/home_page/version.json\\';if (ini_get(\\'allow_url_fopen\\')) {$response = file_get_contents($file);} else if (function_exists(\\'curl_init\\')) {$curl_handle = curl_init($file);curl_setopt($curl_handle, CURLOPT_RETURNTRANSFER, 1);$response = curl_exec($curl_handle); }

We delete or comment out the above script file.

Second, modify the localization time

Find the libraries/Util.class.php file and modify it.

# Find 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);

According to other netizens on the Internet, it is because the time format is different from our local one, resulting in some problems with the processing speed, and it takes a long time to verify and return the value.

Recommended site searches: registered domain name rental, me domain name, rented server Hong Kong server purchase, network server, domain name registration center, website query domain name entrance, free domain name space, ftp free space, Hong Kong's best virtual host