A method _php instance to solve the problem of mysqli extension in phpMyAdmin

phpMyAdmin error is missing mysqli extension. Please check the solution for the PHP configuration

phpMyAdmin is missing mysqli extension. Check the solution for your PHP configuration:
The mysqli extension is missing. Check your PHP configuration.

Open your php.ini-> general in the C:windows directory.
Found it

Copy Code code as follows:

; Extension=php_msql.dll
; Extension=php_mssql.dll
Extension=php_mysql.dll
Extension=php_mysqli.dll

Which extension needs to be turned on, just remove the semicolon from the front of the line, and be aware of restarting Apache or IIS

Solution steps:
1. See if there are any php_mysqli.dll files in PHP's ext directory
If so, continue with the following steps. If not, reload PHP.
2. Open PHP.ini and find

Copy Code code as follows:

; Extension=php_mysqli.dll

Put the preceding semicolon ";" Remove, change to

Copy Code code as follows:

Extension=php_mysqli.dll

3. Find

Copy Code code as follows:

; extension_dir= "./ext"

Put the preceding semicolon ";" Remove, change to (relative to the installation path of PHP ext directory)

Copy Code code as follows:

Extension_dir = "E:\php\ext"

e:php for PHP storage directory

4. Copy the php.ini to the C:windows
5. Copy Libmysql.dll to the System32 directory under Windows (this is critical)
6. Restart IIS (not a Web site)

Run Iisreset/restart under cmd

If the above method does not work, you can refer to the following method operation

The first step, the output phpinfo () to see if the MySQL module is successfully loaded, if the successful loading instructions you ghost, otherwise look at the second step,

What is the reason for phpinfo () without MySQL module under IIS?
The original PHP was installed with. msi, and then all of them started again, and they were installed in the form of a compressed package.
PHP.ini is also configured to copy to Windows, copy Libmysql.dll to System32.
Then the test succeeds ...
The second step is to see if the Extension_dir settings are correct
Step three, see if you want to copy the Libmysql.dll file to the C:windowssystem32

1, does not install the MySQL database correctly, in the system service MySQL related service does not start (please check correctly installs the MySQL method)

2, in the system system32 (C:WINDOWSSYSTEM32) directory is missing libmysql.dll files, the solution is to find the PHP directory Libmysql.dll, and the Libmysql.dll copy to C: Windowssystem32 directory, and then restart the Web service.

3, in the C:windows directory in the php.ini file, there is no "; Extension=php_mysql.dll" in the front of a ";" Remove, so you cannot use the corresponding function, the solution is to open the php.ini file

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

You may report such a mistake when you open the phpMyAdmin.

The mysqli extension is missing. Check your PHP configuration. <a href= "Documentation.html#faqmysql" target= "Documentation" ></a>

You can follow these several methods to check:

1. check php.ini; Extension=php_mysqli.dll is not already enabled to remove the front;

2. check php.ini Extension_dir address is not pointing to the PHP directory of the EXT directory This step is the key I was in this step of the question I put extension_dir = "E:\www\php54\ext" It's set to your own directory.

3. Check to see if Lib_mysql.dll has been copied to the Windows directory. This DLL file has many forms of libmysql_d.dll, so watch yourself.

4. Check the PHP installation directory ext directory, Php_mysqli.dll file is not the existence of the network also indicates that the best use of Zip package decompression does not appear file loss

5. View the PHP detail page <?php phpinfo (); To see if MySQL and mysqli have started this step is to check that you have not opened the mysqli
No, you're looking for the MYSQLI keyword that you can't see on the PHP detail page.

Finally, pay attention to!!!! Restart Apache

Add:

A whole day has been done or did not do a good job on the internet to see a lot of solutions are not used.

First of all, I absolutely promise:

1: I have definitely put the php.ini in the Extension_dir = "C:/myenv/php-5.3.5/ext" semicolon removed,
Also written on the path. This excludes

2: I guarantee that the MySQL feature has been enabled to Extension=php_mysql.dll in php.ini

Extension=php_mysqli.dll the semicolon in front of this exclusion

3:php in the Ext file there is absolutely php_mysqli.dll and php_mysql.dll this exclusion

4:php and Apache consolidations are feasible phpinfo () can be displayed, but no MySQL blocks are found.
Only the MYSQLND option is in, and configuration File (php.ini) Path C:\WINDOWS excluded

5: The above I think of the change system variable, is the Internet some people say it php.ini,**.dll copy
Go under Windows or under Syetem32. But it didn't work out.

6. Is in no way reinstall, uninstall many times. The problem cannot be solved, the MySQL can be started under DOS

High point solution, the above method should not be proposed, are not used. The hero helps me analyze and analyze. Give me 50 more points!
The Phpadmin version has also been changed. It's still not working.

The

is finally resolved. If you encounter this situation, and the above methods are not used. Then you can try the following methods.

1, put ... /mysql/bin/libmysql.dll Copy to php5.0 below, and copy to Php5.0/ext directory
2, copy LibmySQL.dll Php5ts.dll two files to Windows/system32
3, the php5.0 root directory under the php.ini copy to the Windows directory, (if the php.ini must be configured)
4, at this time if there is no problem can connect to the database to test the fact that the key step is to LibmySQL.dll This file, it is not the original php5.0 the following, but the MySQL file with the LibmySQL.dll