Body
debugging PHP Database Today MySQL, in the unit's computer installed phpMyAdmin database management software, originally is very simple thing, but there are a few problems:
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.
In order to prepare for a rainy day, the problems encountered in the solution to the Floating easy blog, save the future encounter such problems and read the document everywhere, looking for solutions.
As the latest version of phpMyAdmin has been updated to 2.11.5.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 Flymorn also phpMyAdmin2.11.5.1 configuration steps are listed below; In order to switch and debug PHP Convenient, I use the Windows system, local debugging.
1. Download the phpMyAdmin installation package first:
To the foreign official website, click on 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 Flymorn's local storage location is D:\www\phpmyadmin.
2. Locate the/libraries/config.default.php file in the phpMyAdmin folder (the old version is the config.inc.php file under the root directory) and open it for editing with a support UTF-8 encoded WordPad.
3. Find $cfg [' Pmaabsoluteuri ']
Modify the URL of the phpmyadmin that you will upload to the space
such as: $cfg [' pmaabsoluteuri '] = ' http://www.piaoyi.org/phpmyadmin/';
Here because I was debugging locally, I changed to $cfg[' pmaabsoluteuri '] = ' http://localhost/phpmyadmin/';
Note: Do not miss the last backslash/and the beginning of HTTP.
4. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with default, with exception, without modification)
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 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 '] = ' www.piaoyi.org ';
The www.piaoyi.org here itself is freely defined, not exceeding 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)
8, find $cfg [' defaultlang '] = ' zh '; (Here is the choice of language, en for Simplified Chinese meaning) and $cfg [' defaultcharset '] = ' gb2312 '; (Modify the default encoding to GB)
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 Flymorn 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: C:\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: "The configuration file now requires a top secret phrase password (blowfish_secret)"
Make sure the correct settings are in the config.default.php file:
$cfg [' Servers '] [$i] [' Auth_type ']= ' cookies ';
While
$cfg [' blowfish_secret '] = ' www.piaoyi.org '; (This value is written casually, just can't leave blank)
In fact, I met the problem is really depressed, if according to the configuration method I mentioned above, should not prompt this error. After 2 hours of continuous modification of the config.default.php configuration file, I always prompt this error, almost reached the edge of the crash.
Then there is an epiphany, suddenly found: I changed the Auth_type Authentication mode to HTTP, changed to config, the open page always appears this error, that is, changed the authentication mode, and did not work for phpMyAdmin, Is it the other configuration file that determines the phpMyAdmin in effect?
Immediately came to phpMyAdmin root directory, impressively found that the root directory has a config.sample.inc.php file exists at the same time, there is a file config.inc.php also exist!! And this is the previous old version of the configuration file, the original is this file pounded ghosts. Delete config.inc.php immediately, then go to debug page, the error disappears! Problem solving.
It appears that the config.inc.php configuration file under the phpMyAdmin root directory has a higher priority than/libraries/ config.default.php configuration file is high, the system is to call the root directory in the configuration file, and then the Libraries folder in the configuration file, Ai, this problem, tossing so long, alas. It's all settled, sigh.
Question fourth: "#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.
Question fifth: "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. I still suggest, do not worry about the problem, carefully read the document, multi-reference to the predecessors of the solution, although not necessarily applicable, but you will have some inspiration. More hands-on, more experimentation, no problems can overwhelm you.
Author: pureboy
http://www.bkjia.com/PHPjc/478079.html www.bkjia.com true http://www.bkjia.com/PHPjc/478079.html techarticle text: Debugging PHP database Today MySQL, in the unit's computer installed phpMyAdmin database management software, originally is very simple thing, but there are a few problems: 1/Unable to load the MCrypt extension ...
