Solution to the lack of mysqli extension in phpmyadmin

This article describes in detail how to solve the problem of mysqli extension in phpmyadmin. For more information, see phpmyadmin.

The mysqli extension is missing in the phpMyAdmin error. Check the PHP configuration solution.

PhpMyAdmin lacks the mysqli extension. Check the PHP configuration solution:
The mysqli extension is missing. Check the PHP configuration.

Open your php. ini-> in the C: WINDOWS directory.
Find

The code is as follows:
; Extension = php_msql.dll
; Extension = php_mssql.dll
Extension = php_mysql.dll
Extension = php_mysqli.dll

To enable the extension, remove the semicolon before this line. restart Apache or IIS.

Solution:
1. check whether the php ext directory contains the php_mysqli.dll file.
If yes, continue with the following steps. Reinstall php if no
2. open php. ini and find

The code is as follows:
; Extension = php_mysqli.dll

Remove the semicolon ";" and change it

The code is as follows:
Extension = php_mysqli.dll

3. find

The code is as follows:
; Extension_dir = "./ext"

Remove the semicolon ";" and change it to (the ext directory relative to the php installation path)

The code is as follows:
Extension_dir = "e: \ php \ ext"

E: php is the directory for storing php

4. copy php. ini to c: windows.
5. copy libmysql. dll to the System32 directory under Windows (this is critical)
6. restart IIS (not a website)

Run iisreset/RESTART in cmd

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

Step 1: output phpinfo () to check whether the MySQL module is successfully loaded. if the MySQL module is successfully loaded, you will be confused. otherwise, check the second step,

Why does phpinfo () have no mysql module in IIS?
The original php was installed by. msi, and all of them were re-installed in the form of a compressed package.
Copy the php. ini file to windows and copy libmysql. dll to system32.
Then the test is successful...
Step 2: Check whether the settings of extension_dir are correct.
Step 3: Check whether the libmysql. dll file is copied to c: windowssystem32.

1. the Mysql database is not correctly installed, and Mysql-related services are not started in the system service (please check the correct method for installing Mysql)

2. libmysql is missing in the system32 (C: windowssystem32) Directory of the system. dll file. the solution is to find libmysql in the php directory. dll, and libmysql. copy the dll to the C: windowssystem32 directory and restart the Web service.

3. in the C: windows directory, php. in the INI file, the previous ";" in "; extension = php_mysql.dll" is not removed, so the corresponding function cannot be used. the solution is to open php. ini file

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
You can delete all other user permissions (which can be retained, but the security is not high. we recommend that you delete them), and then restart MYsql and Web services.

This error may be reported when you open phpmyadmin,

The mysqli extension is missing. Check the PHP configuration.

You can perform the following checks:

1.Check whether php. ini; extension = php_mysqli.dll is enabled or not;

2.Check php. if the ini extension_dir address points to the ext Directory of the php Directory, this step is critical. I am on this step. I will set extension_dir = "e: set \ www \ php54 \ ext "to your own directory.

3.Check whether lib_mysql.dll has been copied to the windows directory. this dll file has multiple forms of ununderlined libmysql_d.dll.

4.Check whether the php_mysqli.dll file exists online in the ext Directory of the php installation directory. it also indicates that it is best to decompress the zip package without File loss.

5.View php details page To see if mysql and mysqli have been started, check whether you have enabled mysqli.
If the mysqli keyword is not enabled, you cannot view it on the php details page.

Last Note !!!! Restart Apache