phpmyadmin download phpMyAdmin installation configuration method and problem solving

Here is a brief review: basically all the problems that should be encountered have been encountered. The key is to check more information and use more brains to solve the problem.
1/Unable to load the mcrypt extension, please check the PHP configuration;
2/The configuration file now requires a top-secret phrase password (blowfish_secret);
3/#2003-The server is not responding.
Since the latest version of phpMyAdmin has been updated to 3.1.3.1, many configuration methods circulated on the Internet are from the old version and are no longer suitable for the configuration requirements of the new version; so pharmar also put the configuration steps of phpMyAdmin3.1.3.1 It is also listed below; in order to facilitate switching and debugging PHP, I use the windows system and debug locally.
1. Download the phpMyAdmin installation package first:
Go to the official foreign website http://www.phpmyadmin.net/, click the "DOWNLOADS" link on the navigation bar to enter the download page, select the "all-languages.zip" version to download Locally, decompress; put the decompressed file into the phpmyadmin folder in the virtual root directory specified by the system (the folder name can be customized). For example, the local storage location of pharmar is D:Program FilesApachehtdocsPhpadmin.
2. Find the config.sample.inc.php file in the phpmyadmin folder and rename it to the config.inc.php file. Open it with a WordPad that supports UTF-8 encoding for editing.
3. Search for $cfg['Servers'][$i]['host'] = 'localhost'; (Usually use the default, there are exceptions, no need to modify it)
5. Search for $cfg['Servers'][$ i]['auth_type'] = 'cookie';
Use config for debugging on your own machine; if you use cookies in the network space, since we have added the URL before, we will change it to cookie.
My personal suggestion: Whether it is local or online, it is recommended to set cookies, safety first.
At the same time, when the auth_type value is set to cookie, there is another place that needs to be modified:
$cfg['blowfish_secret'] = '';
Change to: $cfg['blowfish_secret'] = '123456';
The '123456' here can be defined by yourself, no more than 46 characters. If this field is left blank, the second error mentioned above will appear: "The configuration file now requires a top-secret phrase password (blowfish_secret)".
6. Search $cfg['Servers'][$i]['user'] = 'root'; // MySQL user (user name, use root on your machine; on the Internet, it is usually your ftp user name, virtual The hosting provider will tell you; generally do not modify it)
7. Find $cfg['Servers'][$i]['password'] = '123456'; // MySQL password (modify 123456 to connect to your MYSQL database) User password)
At this point, phpMyAdmin has been configured OK; you can open http://localhost/phpmyadmin/ to access the convenient and fast graphical management software phpMyAdmin. Regarding other options in the configuration file not mentioned in this article, you don’t need to worry about it or modify it. The specific how to operate phpMyAdmin is beyond the scope of this article, but the graphical interface is easy to understand and you will be able to use it after just a few glances (reference).
Let’s talk about several problems that pharmar encountered during the installation and configuration of phpMyAdmin.
First question: "Unable to load mcrypt extension, please check PHP configuration".
1. The Mysql database is not installed correctly, and the Mysql-related services in the system service are not started.
2. The libmcrypt.dll file is missing in the system’s system32 (C:windowssystem32) directory. The solution is to find libmcrypt.dll in the php directory, copy libmcrypt.dll to the C:windowssystem32 directory, and then restart the web service. .
3. In the php.ini file in the PHP directory, the previous ";" in ";extension=php_mcrypt.dll" has not been removed, so the corresponding function cannot be used. The solution is to open the php.ini file and find; Change extension=php_mcrypt.dll to extension=php_mcrypt.dll //Remove the previous; to make it effective
4. The Mysql directory does not have read permissions. The correct directory permissions are as follows:
administrator full control
system full control
user read plus Run
Delete all other user permissions (you can also keep them, but the security is not high, it is recommended to delete them), and then restart the MYsql service and Web service (it is recommended to restart the server after modifying this).
5. If none of the above methods work, use this method: Desktop>My Computer>Right-click Properties>Advanced>Environment Variables>System Variables>New
Name: phpdir
Value: D:Program FilesPhp( Which directory is your PHP in?)
(Reference source: address)
Second question: "Unable to load the mysql extension, please check the PHP configuration"
Copy libmySQL.dll in the PHP directory to: c:windowssystem32 , and then restart APACHE.
Third question: "#2003-Server not responding".
When encountering this problem, it is most likely that the MYSQL database has not been started. It is recommended to start MYSQL directly in: Control Panel-Administrative Tools-Services. Regarding whether to start, you can check whether there is a process such as "mysqld-nt.exe" in the task manager. If there is, it means that mysql has been started.
Another important reason is that the port is not the default 3306 during installation. For example, I did. During the installation process, because a program occupied 3306, I changed it to 3307, so no matter what, it displays: "#2003-Server not responding. ".Finally found the reason. Just add one more:
$cfg['Servers'][$i]['port'] = '3307';
The fourth question: "No PHP extension setting mbstring found".
Modify the PHP.INI file under C:WINDOWS, find ;extension=php_mbstring.dll, remove;, save PHP.INI, and restart Apache.
Just don’t encounter these problems. But for novices, when they encounter it for the first time, they usually look everywhere for solutions. When a lot of methods on the Internet are not applicable, they will feel so helpless. Be sure to read the official documentation, although it is in English, it is still very useful.

The above introduces the phpmyadmin download phpMyAdmin installation configuration method and problem solving, including the content of phpmyadmin download. I hope it will be helpful to friends who are interested in PHP tutorials.