Now make a simple review: basically should encounter the problems are met, the key is to find more information, multi-brain can solve the problem.
1/Unable to load mcrypt extension, please check PHP configuration;
2/config file now requires top secret phrase password (blowfish_secret);
3/#2003-the server is not responding.
As the latest version of phpMyAdmin has been updated to 3.1.3.1, many of the online distribution methods are old versions of the previous version, has not adapted to the new version of the configuration requirements; so Pharmar also phpMyAdmin3.1.3.1 configuration steps are listed below; In order to switch and debug PHP convenient , I am using Windows system, local debugging.
1. Download the phpMyAdmin installation package first:
To the foreign official website http://www.phpmyadmin.net/, click the "DOWNLOADS" link on the navigation bar to enter the download page, select "All-languages.zip" version to download to the local, unzip To place the extracted files in the phpMyAdmin folder (customizable folder name) under the system-specified virtual root directory, such as Pharmar's local storage location is D:\Program files\apache\htdocs\phpadmin.
2. Locate the config.sample.inc.php file in the phpMyAdmin folder and rename it to config.inc.php file. Open for editing with WordPad that supports UTF-8 encoding.
3. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with default, with exception, without modification)
5. Find $cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';
Debug in your own machine with config; if the space on the network with cookies, here we have already added the URL in the previous, the change into a cookie.
My personal advice: whether it is local or on the network, it is recommended to set cookies, security first.
Also, when the value of Auth_type is set to a cookie, there is another place to make the appropriate changes:
$cfg [' blowfish_secret '] = ';
Change to: $cfg [' blowfish_secret '] = ' 123456 ';
Here's the ' 123456 ' to define for yourself, no more than 46 characters. If this place is left blank, the 2nd error mentioned above will appear: "The configuration file now requires a top secret phrase password (blowfish_secret)".
6. Find $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL User (username, your own machine with root; in the Internet generally for your FTP user name, virtual host provider to tell you; do not modify)
7, find $cfg [' Servers '] [$i] [' password '] = ' 123456 '; MySQL password (123456 modified to connect your MySQL database user password)
Here, phpMyAdmin has been configured to complete OK; You can turn on http://localhost/phpmyadmin/to access the easy and fast graphical management software phpMyAdmin. For the other options in the configuration file that are not mentioned in this article, you can take care of it and do not need to change it. about how to operate phpMyAdmin is not in the scope of this article, but the graphical interface, is easy to understand, a little look will be used (reference).
Let's talk about some of the problems that Pharmar encountered during the installation of configuration phpMyAdmin.
First question: "Unable to load the mcrypt extension, check your PHP configuration."
1, the MySQL database is not installed correctly, in the system service MySQL related services did not start.
2, in the system system32 (C:\WINDOWS\SYSTEM32) directory is missing Libmcrypt.dll file, the solution is to find the PHP directory Libmcrypt.dll, and copy Libmcrypt.dll to c \ Windows\System32 directory, and then restart the Web service.
3, in the PHP directory of the php.ini file, there is no "; Extension=php_mcrypt.dll" in the previous ";" Remove, so can not use the corresponding function, the solution is to open the php.ini file, find; Extension=php_mcrypt.dll change to Extension=php_mcrypt.dll//Remove the front; 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
All other user rights are removed (also retained, but not highly secure, recommended for deletion), and then restart the MySQL service and Web service (it is recommended to restart the server after modifying this item).
5, the above methods are not, then use this method: Desktop > My Computer > Right-click Properties > Advanced > Environment Variables > System Variables > New
Name: Phpdir
Value: D:\Program files\php (what directory is your Php in?)
(Reference Source: Address)
Second question: "Unable to load MySQL extension, please check PHP configuration"
Copy the LibmySQL.dll in the PHP directory to: C:\Windows\System32, and then restart Apache.
The third question: "#2003-the server is not responding."
This problem is mostly the MySQL database does not start, it is recommended to directly in: Control Panel-management tools-service inside the MySQL boot. You can see if there is a process such as "Mysqld-nt.exe" in the Task Manager, and if so, it means that MySQL is already started.
Another important reason is that when installing the port is not the default 3306, for example, I am, during the installation process, because the program took up 3306, I changed to 3307 so anyway: "#2003-the server is not responding." Finally found the reason. As long as you add a bar:
$cfg [' Servers '] [$i] [' port '] = ' 3307 ';
Question fourth: "No PHP extension settings mbstring found."
Modify PHP under C:\WINDOWS\. INI file, find; Extension=php_mbstring.dll, remove, save PHP. INI, restart Apache.
These problems, do not touch the poo. But for the novice, the first encounter, their own search solution is generally found everywhere, the online a lot of methods are not applicable to the situation, I will feel how helpless. Be sure to read the official documentation, although it is in English, but it is very useful.
The above describes the PhpMyAdmin download phpMyAdmin installation configuration method and problem solving, including the content of the PhpMyAdmin download, I hope that the PHP tutorial interested in a friend helpful.
