PhpMyAdmin installation and configuration methods and troubleshooting. Now let's make a simple review: we have encountered all the problems. The key is to check more information and solve the problem with more brains. 1. the mcrypt extension cannot be loaded. check the PHP configuration. a simple review is provided. basically, all problems are encountered. The key is to check more information to solve the problem.
1/the mcrypt extension cannot be loaded. check the PHP configuration;
2. the configuration file now requires a top secret phrase password (blowfish_secret );
3/#2003-the server does not respond.
The latest version of phpMyAdmin has been updated to 3.1.3.1. many of the configuration methods circulating on the Internet are earlier versions and are not suitable for the new version; therefore, pharmar also listed the configuration steps of phpMyAdmin3.1.3.1 below. for the convenience of switching and debugging PHP, I used windows and local debugging.
1. first download the phpMyAdmin installation package:
Go to the overseas official website ghost (the folder name can be customized). For example, the local storage location of pharmar is D: \ Program Files \ Apache \ htdocs \ Phpadmin.
2. find the config. sample. inc. php file in the phpmyadmin folder and rename it to the config. inc. php file. Open and edit with a tablet that supports UTF-8 encoding.
3. search for $ cfg ['servers'] [$ I] ['host'] = 'localhost'; (the default value is usually used, and there are exceptions. you do not need to modify the value)
5. search for $ cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';
Debug config in your own machine; if the space on the network uses cookies, now that we have added a URL before, we will change it to a cookie.
My personal suggestion: both on the local network and on the network, we recommend that you set the cookie to be the first in security.
At the same time, when the auth_type value is set to cookie, there is also a need to make the appropriate changes:
$ Cfg ['blowfish _ secret'] = '';
Change to: $ cfg ['blowfish _ secret'] = '000000 ';
The '123456' can be defined at will, with no more than 46 characters. If this field is left blank, the above 2nd error will occur: "The configuration file now requires a top secret phrase password (blowfish_secret )".
6. search for $ cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user (user name, root in your machine; this is generally your ftp user name on the Internet, which the VM provider will tell you. do not change it)
7. search for $ cfg ['servers'] [$ I] ['password'] = '2016 '; // MySQL password (123456 changed to the user password used to connect to your MYSQL database)
Now, phpMyAdmin has been configured. you can enable http: // localhost/phpmyadmin/to access the convenient and convenient graphical management software phpMyAdmin. For other options in the configuration file that are not mentioned in this article, you don't have to worry about it or modify it. The specific operations on phpMyAdmin are not covered in this article. However, the graphical interface is easy to understand and can be used for a moment (refer ).
The following describes several problems that pharmar encountered when installing and configuring phpMyAdmin.
The first problem: "The mcrypt extension cannot be loaded. check the PHP configuration ".
1. the Mysql database is not correctly installed, and Mysql-related services are not started in the system service.
2. libmcrypt is missing in the system32 (C: \ windows \ system32) Directory of the system. dll file. the solution is to find libmcrypt under the php directory. dll, and libmcrypt. copy the dll to the C: \ windows \ system32 directory and restart the Web service.
3. PHP under the php directory. in the INI file, the previous ";" in "; extension = php_mcrypt.dll" is not removed, so the corresponding function cannot be used. the solution is to open php. ini file, find it; replace extension = php_mcrypt.dll with extension = php_mcrypt.dll // remove the previous one to make it take effect.
4. the Mysql Directory has no read permission. the correct directory permission is as follows:
Full administrator control
Full system control
User reading and running
All other user permissions can be deleted (or retained, but the security is not high, it is recommended to delete), and then restart the MYsql service and Web service (it is recommended to modify this item and then restart the server ).
5. if none of the above methods works, use this method: desktop> My Computer> right-click Properties> Advanced> environment variables> System variables> New
Name: phpdir
Value: D: \ Program Files \ Php (in what directory is your PHP)
(Reference source: Address)
The second problem: "mysql extension cannot be loaded. check the PHP configuration"
Copy libmySQL. dll in the PHP directory to: c: \ windows \ system32, and restart APACHE.
Third question: "#2003-the server has not responded ".
Most of these problems occur when the MYSQL database is not started. we recommend that you directly start MYSQL in the control panel-management tools-service. You can run a process such as running mysqld-nt.exe on the task manager. If yes, mysql is started.
Another important reason is that the port is not 3306 by default during installation. for example, during installation, I changed the port to 3306 because a program occupies 3307: "#2003-the server does not respond ". Finally, find the cause. You just need to add one:
$ Cfg ['servers'] [$ I] ['port'] = '000000 ';
Fourth problem: "No PHP extension settings mbstring are found ".
Modify the PHP. INI file under C: \ WINDOWS \ and find; extension = php_mbstring.dll; remove it, save PHP. INI, and restart Apache.
These problems will not happen. However, for a newbie, if he finds a solution for the first time, he usually searches everywhere. if a lot of methods on the Internet are not applicable, he may feel helpless. You must refer to the official instruction documents. although it is in English, it is still very useful.
Bytes. 1/the mcrypt extension cannot be loaded. check the PHP configuration ;...
