PhpMyAdmin lacks the mysqli extension. 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:	Copy code
; 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:	Copy code
; Extension = php_mysqli.dll

Remove the semicolon ";" and change it

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

3. Find

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

Remove the semicolon ";" and change it to (the ext directory relative to the php installation path)
Extension_dir = "e: phpext"
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.
According to the configured php. ini, copy it to winnt, 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.