phpMyAdmin2.11.6 installation Configuration Method _php Skills

1/Unable to load the mcrypt extension, please check the PHP configuration;
2/configuration file now requires a top-secret phrase password (blowfish_secret);
3/#2003-the server is not responding.

In order to prepare for a rainy day, the problems encountered in the solution to the drift of the blog, so as not to encounter such problems in the future to read documents everywhere, to find solutions.

Due to the current phpMyAdmin version has been updated to 2.11.5.1, many of the online distribution methods are old versions, has not been adapted to the new version of the configuration requirements; so Flymorn by the way also put phpMyAdmin2.11.5.1 configuration steps are listed below; To switch and debug PHP Convenient, I am using the Windows system, local debugging.

1, first download phpMyAdmin installation package:
To foreign official website http://www.phpmyadmin.net, click on the navigation bar "DOWNLOADS" link into the download page, select the "All-languages.zip" version of the download to the local, decompression , place the uncompressed file in the phpMyAdmin folder (customizable folder name) under the system-specified virtual root directory, such as Flymorn's local storage location is D:\www\phpmyadmin.

2, find the phpMyAdmin folder in the/libraries/config.default.php file (the old version is the root of the config.inc.php file), with the support of UTF-8 encoded WordPad open for editing.

3. Find $cfg [' Pmaabsoluteuri ']
Modify the URL for the phpmyadmin you will upload to the space
such as: $cfg [' pmaabsoluteuri '] = ' http://www.jb51.net/phpmyadmin/';
Here because I am debugging locally, I change to $cfg[' pmaabsoluteuri ' = ' http://localhost/phpmyadmin/';
Note: Do not omit the last backslash/and the beginning of HTTP.

4. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with the default, there are exceptions, you can not modify)

5. Find $cfg [' Servers '] [$i] [' auth_type '] = ' config ';
Debug in your own machine with config, if the space on the network with cookies, here we have added a URL before, we modify the cookie.
I personally suggest: whether local or online, are recommended to set cookies, security first.
Also, when the Auth_type value is set to a cookie, there is another place to make the appropriate changes:
$cfg [' blowfish_secret '] = ';
Change to: $cfg [' blowfish_secret '] = ' www.jb51.net ';
The www.jb51.net here is freely defined, 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, use root in your own machine), General online for your FTP user name, virtual host provider to tell you;

7. Find $cfg [' Servers '] [$i] [' password '] = ' 123456 '; MySQL password (123456 modified to connect to your MySQL database user password)

8, find $cfg [' defaultlang '] = ' en '; (Here is the choice of language, en for the meaning of Simplified Chinese) there are $cfg [' defaultcharset '] = ' gb2312 '; (modify default encoding to GB)

Here, phpMyAdmin has been configured to complete OK, you can open http://localhost/phpmyadmin/access to convenient and efficient graphical management software phpMyAdmin. For other options in the configuration file not mentioned in this article, you don't have to worry about it or change it. about how to operate phpMyAdmin is not covered in this article, but the graphical interface, is easy to understand, a little look will be used (reference).

Let's talk about the 3 problems that Flymorn encountered during the installation of the configuration phpMyAdmin.

First question: "Unable to load MCrypt extensions, check your PHP configuration."

1, does not install the MySQL database correctly, in the system service MySQL related service does not start.
2, in the system system32 (C:\WINDOWS\SYSTEM32) directory is missing libmcrypt.dll files, the solution is to find the PHP directory Libmcrypt.dll, and libmcrypt.dll copy to C:\ Windows\System32 directory, and then restart the Web service.
3, in the PHP directory in the php.ini file, there is no "; Extension=php_mcrypt.dll" in the front of a ";" Remove, so can not use the corresponding function, the solution is to open the php.ini file, find, Extension=php_mcrypt.dll changed to Extension=php_mcrypt.dll///remove front; make it effective
4, the MySQL directory does not 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 reserved, but not safe, recommended for deletion), and then restart the MySQL service and Web service (we recommend that you restart the server after modifying this item).
5, the above methods are not possible, and then use this method: Desktop > My Computer > Right key properties > Advanced > Environment variable > System variable > New
Name: Phpdir
Value: C:\php (what is your PHP directory?)
(Reference Source: Address)

Second question: "The configuration file now requires a top-secret phrase password (blowfish_secret)"

Make sure that you have the correct settings in the config.default.php file:
$cfg [' Servers '] [$i] [' Auth_type ']= ' cookies ';
While
$cfg [' blowfish_secret '] = ' www.jb51.net '; (This value is casually written, you cannot leave it blank)

Actually this problem, I met really very depressed, if follow the configuration method that I mentioned above to do, should not prompt this error. After my 2 hours of constant modification of the config.default.php configuration file, always prompted this error, almost reached the edge of the crash.

Then there is a flash, suddenly found: I changed the Auth_type Authentication mode to HTTP, to config, open the page always appear this error, that is to say, changed the authentication mode, and did not play a role in phpMyAdmin, Is it the other configuration file that determines the phpMyAdmin in effect?

Immediately came to phpMyAdmin root directory, impressively found under the root directory there is a config.sample.inc.php file exists at the same time, there is a file config.inc.php also exist!! And this is the old version of the configuration file, the original is this document ramming ghost. Immediately delete config.inc.php, and then into the Debug page, the error disappeared! Solve the problem.

It appears that the config.inc.php configuration file in the phpMyAdmin root directory has precedence over/libraries/ config.default.php configuration file High, the system is the first call to the root directory of the configuration file, and then the Libraries folder in the configuration file, Ai, this problem, toss for so long, alas. It's settled, I'm relieved.

Third question: "#2003-server is not responding".

Encountered this problem most of the MySQL database is not started, recommended directly in: Control Panel-management tools-services inside the MySQL boot. about whether to start, you can see in the Task manager whether there is "mysqld-nt.exe" such a process, if there is, then the MySQL has been started.

These problems are not met. But for beginners, like me, the first encounter, their own search solutions are generally everywhere to find, online a lot of methods are not applicable to the situation, they will feel how helpless. I still suggest, encounter problems do not worry, read the document carefully, more reference to the next generation of solutions, although not necessarily applicable, but you will have some inspiration. More hands, more tests, no problem can beat you, I watch you yo ^__^