phpMyAdmin installation and problem summarization _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.
Since the latest version of phpMyAdmin has been updated to 2.11.5.1, many of the configuration methods circulated on the Internet are previous versions and have not been adapted to the requirements of the new version; Flymorn by the way also put the phpMyAdmin2.11.5.1 configuration steps are listed below; In order to switch and debug PHP convenience, 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.piaoyi.org/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.blog.com;
The www.blog.com 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
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 php.ini file, find, Extension=php_mcrypt.dll change 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?)
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.blog.com '; (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 is high, the system is first to call the root directory of the configuration file, and then the Libraries folder in the configuration file, 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 used, but you will have some inspiration. More hands, more tests, no problem can beat you, I watch you yo ^__^
The problems that arise:
Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PH P installation properly.
Change the value of Session.auto_start in php.ini to 1 (boot), default is 0 (disabled)
The following error occurred while opening phpmyadmin:
Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PH P installation properly.
and the other program connection is normal, the environment is 2003 II6
Create a folder tmp in the PHP directory
In php.ini find Session.save_path this line, set into Session.save_path = "c:/php/tmp" to get the semicolon off. Ok
All the information on the Internet was wrong, and those people thought it was Extension=php_mbstring.dll's problem!!!