phpMyAdmin installation configuration method and problem solving _php instance

Source: Internet
Author: User
Tags ini mcrypt phpmyadmin
Now make a simple review: basically should encounter problems are encountered, the key is to search more information, more brain can solve the problem.
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.

Due to the current phpMyAdmin version has been updated to 3.1.3.1, many of the online distribution methods are old versions, has not been adapted to the new version of the configuration requirements; so Pharmar by the way also put phpMyAdmin3.1.3.1 configuration steps are listed below; for switching and debugging PHP convenience , I am using the Windows system, debugging locally.

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, such as Pharmar's local storage location is D:\Program files\apache\htdocs\phpadmin.

2, find the phpMyAdmin folder in the config.sample.inc.php file, renamed to config.inc.php file. Open for editing with WordPad that supports UTF-8 encoding.

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

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 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 '] = ' 123456 ';
Here the ' 123456 ' itself 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)

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).

Here's a few questions to Pharmar in the process of installing 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: D:\Program files\php (What is your Php directory?)
(Reference Source: Address)

Second question: "Unable to load MySQL extensions, check your PHP configuration"

Copy the LibmySQL.dll in the PHP directory to: C:\Windows\System32, then restart Apache.

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.
Another important reason is that when the installation of the port is not the default 3306, such as I am, during the installation process, because there is a program occupied by 3306, I changed to 3307 so anyway it shows: "#2003-the server is not responding." Finally found the reason. Just add one bar:
$cfg [' Servers '] [$i] [' port '] = ' 3307 ';

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 are not met. But for beginners, the first encounter words, 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. Be sure to read the official documentation, although it is in English, but it is very useful.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.